Nested IF Statements - Worksheet Function

[Shorty]

How many IF Statements can be nested together on a
worksheet?

For instance, the Syntax is:
IF(logical_test, value_if_true, value_if_false), then what
I need to do is nest the IF States similar to the
following:

IF(IF(IF(IF(IF(IF(logical_test, value_if_true,
value_if_false), , value_if_true, value_if_false),
value_if_true, value_if_false), value_if_true,
value_if_false), value_if_true, value_if_false))

I also need to nest in the "value_if_true"
and "value_if_false" positions.

TIA,

Shorty

 

[Frank Kabel]

Hi
7 nested functions is the max.
If you need so many comparisons in most cases a lookup table and using
VLOOKUP is a better alternative

 

[Shorty]

Frank,

Thanks for the quick response. I'll also investigate
VLookup.

Regards,

Shorty