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

pandurrr · External Since: Nov 12, 2006 Posts: 1

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
pandurrr.RemoveThis@hotmail.com

Gary''s Student · External Since: Oct 01, 2005 Posts: 3350

post an example of what you are trying to accomplish
--
Gary's Student

"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
> pandurrr DeleteThis @hotmail.com

Harlan Grove · External Since: Jan 21, 2004 Posts: 1320

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.

Teethless mama · External Since: Sep 17, 2006 Posts: 1503

Try LOOKUP or VLOOKUP function instead...

"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
> pandurrr.RemoveThis@hotmail.com

Ron Rosenfeld · External Since: Aug 26, 2003 Posts: 2348

On Sun, 12 Nov 2006 09:27:02 -0800, pandurrr
<pandurrr.DeleteThis@discussions.microsoft.com> 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
>pandurrr@hotmail.com

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 · External Since: Dec 09, 2004 Posts: 3582

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

"pandurrr" <pandurrr.DeleteThis@discussions.microsoft.com> wrote in message
news:6EC1AE53-3E7C-4C30-B79F-F5893D2D62B8@microsoft.com...
>
> 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
> pandurrr.DeleteThis@hotmail.com

kassie · External Since: Mar 09, 2006 Posts: 185

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
> pandurrr.TakeThisOut@hotmail.com

shail · External Since: Jul 25, 2006 Posts: 83

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
> pandurrr.DeleteThis@hotmail.com