if function

[Guest]

--
My Name is DILEEP KUMAR
Sir i want use If function in one cell 20 times. but it work only 7 time.

please solve my this problem as soon as possible thanks.

i am waiting for your positive response.

 

[David Biddulph]

--
My Name is DILEEP KUMAR
Sir i want use If function in one cell 20 times. but it work only 7 time.

please solve my this problem as soon as possible thanks.

i am waiting for your positive response.

7 is as deep as the nesting will go. You'll need to find an alternative
construction.

 

[BruceP]

As you've noticed, Excel only supports 7 nested IFs.

You can get around this by using a series of nested VLOOKUPS, based on
named ranges. The formula can get a bit cumbersome, so any example I
could give would be meaningless to you without your data.

Hope this helps.

 

[Guest]

you can create a module on the VBA to solve it.

regards

"David Biddulph" escreveu:

 

[Gary]

Try "IF(AND" or "IF(OR"

or elaborate on what are you trying to do.