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

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…

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.

1 Like