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
The restriction is seven levels of nesting. You have 8 IFs in total of which 7 are nested.
Enjoy,
Tony
---------------------------------------------------------------
Give a man a fish and he'll eat for a day.
Teach him how to fish and he'll sit in a boat and drink beer all day.
I'm (slowly) building my own site: www.WordArticles.com
Hello Tony,
Thanks for the good news! and for the quick tip.
I do enjoy it.
Best regards,
Nee
Posting Permissions
Reply With Quote
