Link to home
Start Free TrialLog in
Avatar of Patrick
Patrick

asked on

Nested IF AND statements in Excel

I'm have a bit of trouble with a IF AND statement in Excel:

=IF(AND(J55="Lodge or dorm floor",J62="Yes"),F11*-0.2,IF(AND(J62="Yes",J55="House"),F11*-0.4),IF(J62="No",F11+0))

Long and the short:
IF J55 = Lodge or dorm AND j62 = Yes THEN F11*-0.2
IF J55 = House and J62 = YES THEN F11*-0.4

This works - but when I want to show a No field for J62 (or even a blank) the equation is broken and shows FALSE. When someone selects NO, I'd like nothing to happen.

What am I doing wrong?
ASKER CERTIFIED SOLUTION
Avatar of NBVC
NBVC
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Patrick
Patrick

ASKER

PERFECT!!!
Avatar of Patrick

ASKER

Sorry - If nothing is entered, I still get false - how can I leave the cell empty and not show FALSE in the Function?
You shouldn't get FALSE with my formula.  You should get a blank if nothing has been entered in the other cells.
Avatar of Patrick

ASKER

When I throw in your formula, it's perfect. When I initially put in information into the cells to satisfy the formula, it works perfect. When I clear our the values, it' returns a FALSE. What am I doing wrong?

NOPE - you're right - works perfectly!
Ok.. see that you got it.  Great!
Avatar of Patrick

ASKER

Thanks again!!!!