PDA

View Full Version : Only 7 IF's -- but thats strange!



joelle
04-05-2006, 03:04 PM
Hello Experts,

I got this puzzle about only 7 IF's are allowed for a formula, and hope someone would tell me about it.

I have the attached simple case that takes 8 IF's, and the formula still works??? In real world, my formula is more complex that needs up to 8 conditions and "has to" work right, so if you could confirm this, I really appreciate it.

(attachment, pls see "green" field)

Nee

TonyJollans
04-05-2006, 03:35 PM
The restriction is seven levels of nesting. You have 8 IFs in total of which 7 are nested.

joelle
04-05-2006, 03:48 PM
Hello Tony,
Thanks for the good news! and for the quick tip.
I do enjoy it.

Best regards,
Nee