I WANT TO USE =IF(AND(),IF(AND(),IF(AND()).
Hi,
For the IF you can nest it 7 levels deep in 2003 and earlier, in 2007 you
can nest 64 levels deep. However, often you can beat these limits by using
VLOOKUP or by concatenating the IF's. =IF(A12,B,"")&IF(A5,15,"") and so
on.
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"gopal sharma" wrote:
i want to use if(and) function more than one time. how long can i use this
function in a formula.
|