Matching cells but exclude blanks

Solved/Closed
Tom9o
Posts
11
Registration date
Monday February 18, 2013
Status
Member
Last seen
September 15, 2013
- Updated on Nov 12, 2018 at 01:10 AM
 Hira - Jul 4, 2017 at 08:18 AM
Hello,
I am trying an "IF" formula to see if A1 matches B1 and if so I want to return C1 but if the two cell are blank its working I want to exclude blanks, and it is date's that I am working with.
So if A1 contains 1/1/13 and B1 contains 1/1/13 then it is to return the value in C1. But what is happening also if A1 is blank and B1 is blank it is returning the value in C1 and I don't want that. Any help appreciated

10 replies

Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
68
Mar 11, 2013 at 02:36 PM
Hi Tom9o,

If you are checking a cell for a zero value and the cell is blank, the test evaluates to true. If the range might contain a blank cell, you should use the ISBLANK function to test for a zero value, enter the below mentioned formula in C1 and it should work now:

=IF(ISBLANK(A1),"",IF(B1=A1,A1,""))

Do reply with results.
0
amazing thanks solved my problem :)
0