View Single Post
  #1   Report Post  
THEFALLGUY
 
Posts: n/a
Default 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