Help

"IF a number is less than one number but greater than another" formula?

Topic Labels: Formulas
3265 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Brenda_Carey
5 - Automation Enthusiast
5 - Automation Enthusiast

I want to write something that reads something like, “IF Number is less than 2100 but greater than 1600 than “Awesome”, IF number is less than 1600 than “Perfect””. I’m not sure how to so this…

1 Reply 1
AlliAlosa
10 - Mercury
10 - Mercury

HI Brenda,

Try this:

IF(AND({Number} < 2100, {Number} > 1600), "Awesome", IF({Number} < 1600, "Perfect"))

Note that the above doesn’t take into account if {Number} is exactly 1600 or 2100.