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