Don't use Google Sheets' ISBLANK()


If you've tried to make formulas in Google Sheets using the ISBLANK() function, you probably have noticed its wildly unintuitive behavior: it does not consider "" as blank. No, that's not two visible quotation marks – that's the presence of the string delimiter. So cells with the contents (omitting the initial " used to display the formulas)

resolve to

Despite this somehow charmingly condescending attempt to explain, you're correct in identifying this behavior as wrong. It's the wrong thing to do; it's bad design.

To mitigate this problem, use EQ(LEN(A1), 0), which does what you expect.