Dec 05, 2019 06:31 PM
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…
Dec 06, 2019 08:36 AM
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.