Functions
ISBLANK
True if value is blank
Try it
When to use it
When should I use ISBLANK?
Use ISBLANK to test whether a cell is truly empty, typically inside an IF so you can flag or skip rows that have no data yet.
Is an empty string the same as blank to ISBLANK?
No — ISBLANK is strict: a cell holding an empty string ("") is not truly empty, so ISBLANK("") returns FALSE. Use COUNTBLANK if you want empty strings counted as blank.
Use cases
Text is never blank
Zero is a value, not a blank
Used in
Syntax
ISBLANK(value)