Thread
:
How many IF are authorized?
View Single Post
#
3
Warrio
Posts: n/a
How many IF are authorized?
and I also can separate the forumla in 2 cells by putting in the last ELSE
clause to look in another cell that contains more ifs
Thanks for the hint! it helps
"Chip Pearson" a écrit dans le message de news:
...
You are limited to 7 levels of nested functions. Perhaps you can use
VLOOKUP or CHOOSE instead of a series of IFs.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Warrio" wrote in message
...
Hello!
How many tests functions does Excel authorizes in one formula?
for instance:
=IF(...;...; IF(...;...IF(...,... IF(...;...; .... ))))
I went up to 8, then I get an error message asking me to check the
parentheses the punctuation.. even if it's correct.
Thanks for any suggestion!
Reply With Quote