Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested If/And/Or statements | Excel Worksheet Functions | |||
Nested IF Statements | Excel Worksheet Functions | |||
Nested If Statements | Excel Worksheet Functions | |||
Help with Nested If Statements | Excel Discussion (Misc queries) | |||
Do I need nested IF statements? | Excel Worksheet Functions |