Mind blank - IF AND statement

[Jay3]

Hi,

I need an if statement to return high medium or low based on a 1 - 10 value but I can only get 2 conditions to work and a FALSE if the value is HIGH.

What I'm I doing wrong?

=IF(D10<=3,"Low",IF(AND(D10>3,D10<=6),"Med"))

I thought I could just do ,"High" in between the 2 last brackets but I get "Too many arguments".

Thanks,
Jay

 

[Joe4]

Try:

=IF(D10<=3,"Low",IF(D10<=6,"Med","High"))

Note that you do not need an AND if you you keep working your way up or down (from "lowest to highest" or "highest to lowest"), as a nested IF will STOP at the first true part it finds and ignore eveything else after that.

 

[Jay3]

Try:

=IF(D10<=3,"Low",IF(D10<=6,"Med","High"))

Note that you do not need an AND if you you keep working your way up or down (from "lowest to highest" or "highest to lowest"), as a nested IF will STOP at the first true part it finds and ignore eveything else after that.

Thanks!!

 

[Joe4]

You are welcome!

Just to clarify why you don't need an AND a little further, with a nested function like the one I posted, in D10 was less than 3, it would hit the first IF and stop there. It would never get to the second one. Any value less than 3 will never get past the first one to the second one. That is why you don't need to check to see if it is less than 3 on the second IF.

 

[Eric W]

You could also do something like this:

=LOOKUP(D10,{1,4,7},{"Low","Medium","High"})

It's about a wash for 3 tiers, but if you have more, this scales better.

 

[Jay3]

You could also do something like this:

=LOOKUP(D10,{1,4,7},{"Low","Medium","High"})

It's about a wash for 3 tiers, but if you have more, this scales better.

Never seen that before!? Interesting! Thanks