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!