"IF" function - 7 nested limit
Hi
You can nest IF's on 7 levels - no more. It means you can have max 8 nested
conditions.
NB! I speak about 7 nesting levels, not about 7 IF's in formula. To
understand the difference, compare formulas
=IF(a=b,x,IF(a<b,y,z))
(2 levels)
=IF(a=b,IF(b=c,v,W),IF(a<b,y,z))
(2 levels also)
=IF(a=b,w,x)+IF(b=c,y,z)
(1 level)
Arvi Laanemets
"Ed" wrote in message
...
Hi
Sometimes when I nest 8 "IF" functions the formula executes properly.
I am wondering, will such a formula always execute properly, or could
different conditions cause it to not execute?
In short, would the following be true?
If a formula works, it will always work so, go ahead and use it.
Thankyou
Ed
|