If and isblank dilema

**bbryant1** · 04-19-2013, 05:28 PM

Hello: I am trying to use the formula below, however, it keep returning mismatch in the cell when it shouldn't. Please let me know what I'm doing wrong. Thanks

=IF(AND(A2=B2,ISBLANK(A2))," ","Mismatch")

3/14/2013 1/1/1901 Mismatch
3/22/2013 1/1/1901 Mismatch
3/21/2013 1/1/1901 Mismatch
3/8/2013 1/1/1901 Mismatch
3/9/2013 1/1/1901 Mismatch
3/12/2013 1/1/1901 Mismatch
3/12/2013 1/1/1901 Mismatch
3/7/2013 1/1/1901 Mismatch
1/1/1901 Mismatch
1/1/1901 Mismatch
3/7/2013 3/7/2013 Mismatch

**Lemice** · 04-19-2013, 05:31 PM

Hello,

Can you provide your expected result?
From what I can interpret from your IF formula, it says "If Value on Cell A2 = Value on B2, AND A2 is blank, return " ", if both of them NOT happen at the same time, return "Mismatch") and thus, your formula is working.
Perhaps you wanted it to be

=IF(OR(A2=B2,ISBLANK(A2))," ","Mismatch")

**bbryant1** · 04-22-2013, 11:12 AM

Hello:

Thanks for responding. What I am trying to achieve is If cell A and B are equal then leave cell c blank, If cell A is blank then leave cell c blank, otherwise put mismatch in cell C. If you notice, the last three lines should be blank.

**bbryant1** · 04-22-2013, 11:21 AM

I've tried this as well and it keeps giving mismatch in all fields.

**FDibbins** · 04-19-2013, 05:38 PM

Agree with Lemice, based on what your formula is evaluating, it is returning the correct answer.

Maybe your logic is faulty? What are you trying to achieve?

**mehmetcik** · 04-19-2013, 05:46 PM

Hi

I think this formula is what you are after:

=IF(OR(A11=B11,ISBLANK(A11)),"","Mismatch")

However I don't think that you need the isblank.

So this would work too
.

=IF(A11=B11,"","Mismatch")

**bbryant1** · 04-22-2013, 11:15 AM

Hi Thanks for responding. I tried that however if A2 is blank and B2 has a date, then it will list as mismatch; I don't want that. I want the cells that equal and the blank cells in A2 to return a blank value.

**FDibbins** · 04-22-2013, 11:24 AM

explain exactly what you are trying to achieve?

**Lemice** · 04-22-2013, 01:49 PM

I see, then this formula might be the one you are looking for

=IF(A2=B2,"",IF(AND(NOT(ISBLANK(B2)),ISBLANK(A2)),"","Mismatch"))

Paste it on C2 and drag it down.
This will give "blank" result if Cell A2 = Cell B2, OR A2 blank and B2 not blank (in case both cells are blank, they are equal).
This will give "Mismatch" in all other cases, including the case A2 not blank but B2 blank.