Conditional Formula

[Dave P.]

I want to compare multiple ranges of numbers to a number and when that number
falls within one of those ranges, diplay a given number. For example, say
there are 3 ranges of numbers: 80-84, 85-89, 90-94. I want to compare a
number that will be anywhere from 80 to 94 in a cell to those three ranges.
If the formula to see if the number is in the range 80-84, display the number
5; if the number is in the range 85-89, display the number 6, and if the
number is in the range 90-94, display the number 7. How do I construct that
formula? Thanks in advance for your help.

 

[Jacob Skaria]

Try the below
=IF(AND(A1>=80,A1<=94),LOOKUP(A1,{80,85,90},{5,6,7}),"")

If this post helps click Yes