Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help with Nested If Statements
I have a scenario that has 5 scenarios, and I need to nest them into one
formula within a single cell: IF(IX,IF(H<W,X-W,X-H)) IF(I<=X,IF(H=W,I-H,I-W)) IF NEITHER OF THE ABOVE STATEMENTS IS TRUE, THEN RETURN '0' Here are the five scenarios broken down: 1) H<U, IV 2) H=U, IV 3) H=U, I<=V 4) H<U, I<=V 5) None of the above, so return '0' Thank you for any help, THEFALLGUY |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
what is the max no. of nested Ifs can an If Statements have in EXC | Excel Discussion (Misc queries) | |||
Nested IF statements | Excel Worksheet Functions | |||
Employing constant arrays to limit nested IF statements. | Excel Worksheet Functions | |||
Problem with data using IF and Nested IF statements possibly??? | Excel Discussion (Misc queries) | |||
nested statements | New Users to Excel |