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

P

pandurrr

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)
 
H

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

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
 
K

kassie

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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top