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

Increasing Nesting Limit of 'IF' Function in Excel

Hello Redishetti,

I understand that you are looking to increase the nesting limit of the 'IF' function in Excel beyond the default limit of 7 levels. While it is not recommended to use such complex nested functions, there is a workaround that you can use to achieve your requirement.

One way to increase the nesting limit of the 'IF' function is to use a combination of 'IF' and 'AND' or 'OR' functions. By using these functions, you can create more complex logical tests that can be used in place of nested 'IF' functions.

Here is an example of how you can use the 'AND' function to create a logical test that can replace a nested 'IF' function:

1. =IF(AND(A10,A1<10), "Value is between 0 and 10", IF(AND(A1=10,A1<20), "Value is between 10 and 20", "Value is greater than or equal to 20"))

In this example, we have used two 'AND' functions to create a logical test that checks if the value in cell A1 is between 0 and 10, between 10 and 20, or greater than or equal to 20. We have then used the 'IF' function to return the appropriate message based on the result of the logical test.

By using this method, you can create more complex logical tests that can replace nested 'IF' functions and increase the nesting limit beyond 7 levels.

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

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

On Sun, 12 Nov 2006 09:27:02 -0800, 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


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

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" wrote in message
...

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

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

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