Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: EASY...for you!

  1. #1
    Guest

    Default

    Trying to build a simple if/then statement measuring ranges. For example:
    Cell A1 is greater than 50 but less than 100.
    Cell A2 is greater than 100 but less than 500.

    I need an if/then statement to say: if A1 is between 50 and 100,then "TRUE", else "false".


  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Bogota, Colombia
    Posts
    11,959
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =AND(A1>50,A1<100)
    Regards,

    Juan Pablo González
    http://www.juanpg.com

  3. #3
    Guest

    Default

    Thanks for the quickk response. But where does the "and" statement fit into the formula with if/then?

    =if(a1>50,"green",if(a1>50,<100,"Blue",0))

    Can't seem to get it to work...

  4. #4
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =if(a1>50,"green",if(and(a1>50,a1<100),"Blue",0))
    ~Anne Troy

  5. #5
    MrExcel MVP Anne Troy's Avatar
    Join Date
    Feb 2002
    Location
    Westwood NJ
    Posts
    2,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    LOL, don't confuse me! ROFL...

    What color do you want if it is, say 60?

    Did you want your first part to be LESS than 50? Just fix my formula above (or Juanito's).
    ~Anne Troy

  6. #6
    Guest

    Default

    Thanks. i noticed that my example was crap - so i took a stab at something else....green & blue.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •