Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » Functions and Formulas » IF/THEN or Conditional Formatting

IF/THEN or Conditional Formatting

Previous | Next
Latest post Thu, Apr 24 2008 10:16 PM by hchanlee. 2 replies.

  • Thu, Apr 24 2008 11:33 AM

    • hchanlee
    • Top 150 Contributor
    • Joined on Thu, Apr 24 2008
    • Posts 2
    • Points 26

    IF/THEN or Conditional Formatting

    Reply |Contact

     I am trying to figure out something that I think Excel should be able to do.  Cell A1 contains a value.  I need cell B1 to display "1-30" if the value in A1 is less than/equal to 30, display "31-60" if cell A1 is between 31 and 60, and to display "61-90" if the value in A1 is between 61 and 90.  I am not sure if I should use IF/THEN or conditional formatting or something else.  Thanks for the help.
    • Post Points: 21

  • Thu, Apr 24 2008 12:43 PM In reply to

    • Nick Hodge
    • Top 10 Contributor
    • Joined on Sun, Dec 23 2007
    • Southampton
    • Posts 336
    • Points 5,771
    • MVP

    Re: IF/THEN or Conditional Formatting

    Reply |Contact |Mark as Not Answer

    IF formulas seem very popular at the minute. If you pan down one message there is one virtually identical, anyhow...

    =IF(A1=<30,"1-30",IF(A1=<61,"31-60",IF(A1<91,"61-90","Out of range")))

    Regards
    Nick Hodge
    Microsoft MVP, Excel
    Southampton, UK
    Filed under:
    • Post Points: 21

  • Thu, Apr 24 2008 10:16 PM In reply to

    • hchanlee
    • Top 150 Contributor
    • Joined on Thu, Apr 24 2008
    • Posts 2
    • Points 26

    Re: IF/THEN or Conditional Formatting

    Reply |Contact |Mark as Answer

     Thanks!  That worked beautifully.  I ended up adding a few more criteria to it.
    • Post Points: 5
Page 1 of 1 (3 items) | RSS
Copyright Excel User Group and the relevant contributors, 2008. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.