Matching cells but exclude blanks

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
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 responses

Zohaib R Posts 2368 Registration date Sunday September 23, 2012 Status Member Last seen December 13, 2018 69
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:


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