Nested if problem

Question

I have a data where in i have to give a nested if formula which is around 10 condition, but if provides only 7. is there any other way other than vlookup where in i can put these condition. for example the conditions are 0-400 401-500 501-600 601-700 701-800 801-900 901-1000 >1000

Please help

Answer

Neeta

I don't know of a way around the 7 nested IFs limitation; but, I think this is definitely a case for VLOOKUP. I think you will like the VLOOKUP a lot better if your lookup range is slightly different than you show above.

If you simply have a column of numbers

0 401 501 601 701 801 901 1000

instead of the ranges (for example 401-500) I think VLOOKUP will work fine; and will be easier on you brain than 10 nested IFs. Alternatively, you could write a userdefined function an use a Select Case structure.