Dear all,

I'm attempting to create a formula that categorises a number dependent on
its value:

<0.75
0.75<X<1
1<X<1.25...
....4.75<X<5.00
X5.00

There are therefore 18 categories.

I can do this using an IF formula:

=IF(B75.00,"HIGH",IF(B74.75,"5.00",IF(B74.50,"4 .75",IF(B74.25,"4.50",IF...
....(B7<0.75,"0.75","ERROR"))))))

However it is only possible to insert around 8 IF's for the FALSE return
before EXCEL returns an error with formula message.

Therefore how do I categorise dependent on 18 outcomes?


Kind regards,

Neil