Hi,

There is one more option You can use IF as much as you can. Write
nested IF functions 7 times and name the cell (say "Cond1"), again the
next 7 IF functions at the other cell and name it (say "Cond2"). Then
at the other cell write the IF function as
=IF(Cond1,Cond1,Cond2)

This way you can use as many as nested IF conditions.

Hope that helps,

Thanks,

Shail


pandurrr wrote:
Hellow friend,

There is a limitation of 7 (Seven) levels for Nested function ( IF function)
in Microsoft Excel .

Will you please let me know, how to increase this nesting limit of 'IF'
function upto 9 or 10 levels, so that I can use the facility for my
requirement.

Will you please help me in this and provide me the solution to

regards

redishetti