Skip to main content

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

  • December 6, 2019
  • 1 reply
  • 15 views
B

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

A
Forum|alt.badge.img+19
  • AlliAlosa
  • Inspiring
  • December 6, 2019

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.

Justin_Barrett
T
Terms & ConditionsAccessibility statement