ISBLANK

Checks whether the specified reference identifies an empty cell.

Syntax

ISBLANK( Any x ) → Logical

Parameters

x

Required. The value to check.

Remarks

If x is a reference to an empty cell, that is, a cell with no data, the function returns TRUE. If x is a number, logical value or text, or a reference to a cell that is not empty, the function returns FALSE. If the cell contains an empty string, it is not considered blank.

Example

Formula

=ISBLANK(A1)
=ISBLANK(0)

See Also

Function Reference
ERROR.TYPE Function
ISERR Function
ISERROR Function
ISNA Function
ISREF Function
ISTEXT Function
TYPE Function