how can I increase nested function 'IF' in EXCEL upto 10 levels

[Guest]

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
(e-mail address removed)

 

[Guest]

post an example of what you are trying to accomplish

 

[Harlan Grove]

pandurrr wrote...
....

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.

There's no way to change this limit. It's built into Excel.

There may be different ways to do what you want to do that don't
require even 7 nested function calls, but you need to provide some
details about what you're trying to do.

 

[Guest]

Try LOOKUP or VLOOKUP function instead...

 

[Ron Rosenfeld]

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
(e-mail address removed)

You will not be able to do that.

You will either need to find a different tool, or accomplish your requirement
using some other features of Excel.
--ron

 

[Biff]

See this:

http://j-walk.com/ss/excel/usertips/tip080.htm

Note the concatenate method. Although it's possible, it should be your
*LAST* option.

Biff

 

[Guest]

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.

 

[shail]

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