Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

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

Topic Labels: Formulas
2300 1
Showing results for 
Search instead for 
Did you mean: 

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

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.