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

"DILEEP KUMAR" wrote in message
...

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

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.


--
BruceP
------------------------------------------------------------------------
BruceP's Profile: http://www.excelforum.com/member.php...o&userid=33653
View this thread: http://www.excelforum.com/showthread...hreadid=547908

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

regards

"David Biddulph" escreveu:

"DILEEP KUMAR" wrote in message
...

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

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

or elaborate on what are you trying to do.

"DILEEP KUMAR" wrote in message
...

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