Without IF's

=IF(ISNA(LOOKUP(A2,{10,14.99,139.99},{1,2,3})),"er ror",LOOKUP(A2,{10,14.99,139.99},{1,2,3}))

Add more ranges to suit.


Gord Dibben MS Excel MVP

On Fri, 14 Aug 2009 22:10:38 GMT, "Quimera" wrote:

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