Nested IF Statements - Worksheet Function
 

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

Nested IF Statements - Worksheet Function
 

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Shorty" schrieb im Newsbeitrag
...
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

Nested IF Statements - Worksheet Function
 

Frank,

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

Regards,

Shorty

-----Original Message-----
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

--
Regards
Frank Kabel
Frankfurt, Germany

"Shorty" schrieb im
Newsbeitrag
...
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


.