If two cells are blank, if statement to show third statement is blank

1. If two cells are blank, if statement to show third statement is blank

I'm working on a spreadsheet to compare data between two cells in multiple rows.

In my "if statement, If the cells are the same, I'd like a "yes" response, and if they are different, I'd like a "no" response. I'm running into difficulty because if the cells are both blank, I'm getting a "yes" response and I'd like that response to be blank.

Any thoughts would be greatly appreciated!

2. Re: If two cells are blank, if statement to show third statement is blank

=IF(COUNTA(A1,B1)<2, "", IF(A1=B1, "Yes", "No"))

3. Re: If two cells are blank, if statement to show third statement is blank

You could also try this:
=IF(AND(ISBLANK(A1),ISBLANK(B1)),"",IF(A1<>B1, "No", "Yes"))

4. Re: If two cells are blank, if statement to show third statement is blank

If A1 & B1 can contain formula Nulls COUNTBLANK is perhaps the safest option of all given Nulls are seen as Blanks (not the case with COUNTA / ISBLANK)

=IF(COUNTBLANK(A1:B1)=2,"",IF(A1=B1,"Yes","No"))

5. Re: If two cells are blank, if statement to show third statement is blank

Thank you all very much!
I used the first suggestion and it worked, but I have printed them all out to have on hand.
Really appreciate the help.

6. Re: If two cells are blank, if statement to show third statement is blank

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated. It is found across from the "time" in each of our posts.)

7. Re: If two cells are blank, if statement to show third statement is blank

Recycled. Thank you, not exactly what I needed but enough to make it work.
=IF(AND(ISBLANK(A35221),ISBLANK(L35221)),"",IF(L35221="","0",IF(L35221<0,"Overdue","Not Overdue")))

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1