Matching cells but exclude blanks
Solved/Closed
Tom9o
Posts
10
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
Hira - Jul 4, 2017 at 08:18 AM
Related:
- Different dates of "end to end encryption message" on blank chat?
- Different dates of end to end encryption message on blank chat ✓ - WhatsApp Forum
- Using web browser page loads but screen blank ✓ - Network Forum
- Voice message downloader - Guide
- Chat gpt for pc - Download - Other
- Encryption And Decryption - Download - Encryption and decryption
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
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.
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.
Jul 4, 2017 at 08:18 AM