Purpose
Test if a cell is empty
Return value
A logical value (TRUE or FALSE)
Syntax
=ISBLANK (value)
Arguments
- value – The value to check.
Usage notes
Use the ISBLANK function to see if a cell is empty or not.
For example, =ISBLANK(A1) will return TRUE if A1 is empty, and FALSE if A1 contains text or formulas.
It’s probably best to think of ISBLANK as meaning “is empty” since it can return true when cells look blank but aren’t.