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