IF formula for a number range specification

  • Thread starter Thread starter Quimera
  • Start date Start date
Q

Quimera

I need a nested IF formula that can assign a code to a range of numbers.
There are 5 ranges.

For example...If (A2>=10 and <=14, "1", IF (A2>=15 and
<=140,"2"),IF(......."5"),"Error"))

I don't know how to define the range.

Thank you for your always helpful help.

Rose
 
Since you didn't post your entire range of numbers, I plugged these in as an
example:

10 - 14
15 - 140
141 - 250
251 - 400
401 - 600

And try this:

=IF(OR(A2<10,A2>600),"Error",MATCH(A2,{10,15,141,251,401}))
 
Back
Top