Forum Discussion
IFNA Blank Cell Output?
Good-morning! This is my first time posting here. I have a question regarding replacing N/A with blank cells. I am using the IFNA function to replace N/A values returned from VLOOKUP with blank ce...
Unfortunately, formulas cannot return a truly blank value, and Microsoft has turned down a very popular request to add that as a new feature 😞
Whether an empty string "" as return value disrupts calculations depends on the calculation:
- A test ISBLANK(cell) will return FALSE for a cell with a formula returning "", but cell="" will return TRUE.
- A formula such as =A1+C1 will return #VALUE! if A1 or C1 contains a formula returning "", but =SUM(A1,C1) will ignore "" (and all other text values)
- The formula =COUNTA(...) will include cells with a formula returning "" in the count, but =COUNT(...) will only count cells with a numeric value (including dates).