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?
pstiffsaeAsked:
Who is Participating?
 
NBVCConnect With a Mentor Commented:
Maybe need to remove a closing bracket...

Try:

=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,"")))
0
 
pstiffsaeAuthor Commented:
PERFECT!!!
0
 
pstiffsaeAuthor Commented:
Sorry - If nothing is entered, I still get false - how can I leave the cell empty and not show FALSE in the Function?
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
NBVCCommented:
You shouldn't get FALSE with my formula.  You should get a blank if nothing has been entered in the other cells.
0
 
pstiffsaeAuthor Commented:
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!
0
 
NBVCCommented:
Ok.. see that you got it.  Great!
0
 
pstiffsaeAuthor Commented:
Thanks again!!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.