Limitations are made to overcome! You ca use LOOKUP tables, if this is
feasible. You can use CONCATENATE or &, if this is feasible. While not the
best way of overcoming the limit, you can actually split an IF statement over
as many columns as you wish. If for argument's sake you have 21 conditions
to check, then in the first column, test for the first 7 conditions, and for
the ELSE part, give a value like NOT DONE. In the 2nd column, if the first
IF column has a result other than NOT DONE, return the result of the first
column, else do the 2nd batch of 6 IF's. Again, if not done yet, return NOT
DONE. In the third column, repeat the process, and use as many columns as
required. In the end, hide all but the last column, and you have it.
"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