The ISBLANK function tests if a specified cell is blank (empty) and if so, returns TRUE; Otherwise the function returns FALSE.

Syntax

=ISBLANK(value)

Arguments

Argument Description
value The supplied value argument is a reference to a cell

Examples

  A B C
1   Formula Result
2 10 ISBLANK(A2) FALSE
3 text ISBLANK(A3) FALSE
4   ISBLANK(A4) TRUE