ISBLANK

Name

Is blank

Description

Tests whether a value, such as a cell, is empty.

Syntax

ISBLANK(value)

Remarks

Returns 1 (True) if value refers to an empty cell or to no data.

Use the ISBLANK function to test a cell, text or numeric value, or a function or expression.

Data Type

Accepts any data. Returns numeric (boolean) data. For more information, see Data Type for Each Cell Type.

Example

ISBLANK(B1) = 0 (False)
ISBLANK(A4) = 1 (True)
ISBLANK(4) = 0 (False)