Checks whether the referenced cell is empty.
Sample Usage
ISBLANK(A2)
IF(ISBLANK(B1),,A1/B1)
Syntax
ISBLANK(value)
-
value
- Reference to the cell that will be checked for emptiness.ISBLANK
returnsTRUE
ifvalue
is empty or a reference to an empty cell, andFALSE
if it contains data or a reference to data.
Notes
-
ISBLANK
returnsFALSE
if the referenced cell has any content, including spaces, the empty string (""
), and hidden characters. In case of unexpectedFALSE
results, try clearing the cell again to remove any hidden characters. -
This function is most often used in conjunction with
IF
in conditional statements.
See Also
ISTEXT
: Checks whether a value is text.
ISREF
: Checks whether a value is a valid cell reference.
ISNUMBER
: Checks whether a value is a number.
ISNONTEXT
: Checks whether a value is non-textual.
ISNA
: Checks whether a value is the error `#N/A`.
ISLOGICAL
: Checks whether a value is `TRUE` or `FALSE`.
ISERROR
: Checks whether a value is an error.
ISERR
: Checks whether a value is an error other than `#N/A`.