if function

D

DILEEP KUMAR

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

David Biddulph

DILEEP KUMAR said:
--
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.
Click to expand...

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

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

Marcelo

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

regards

"David Biddulph" escreveu:
 
Top