Conditional Formula

D

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.
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top