ISBLANK
Returns TRUE if the value is blank.
InformationError Handling & ChecksInformation & Auditing
What it does
Checks if a cell is empty.
Syntax
ISBLANK(value)
Arguments
value(reference) — Cell to check.
Examples
Check Empty
Check if A2 is blank.
FORMULA
=ISBLANK(A2)
RESULT
true
SAMPLE DATA
| A | |
|---|---|
| 1 | Val |
| 2 |