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?
I thought I could just do ,"High" in between the 2 last brackets but I get "Too many arguments".
Thanks,
Jay
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?
Rich (BB code):
=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