How many IF are authorized?
 

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!

How many IF are authorized?
 

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!

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!

How many IF are authorized?
 

Yes you could do that. You might need to watch the order in which you
arrange the two cells.

Why not post your requirement. I often find that contributors here
come up with quite elegant and much simpler solutions than you might
think.

Rgds


On Mon, 7 Nov 2005 19:59:02 +0100, "Warrio"
wrote:

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!







__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________