ISBLANK (is empty?)

<< Click to Display Table of Contents >>

ISBLANK (is empty?)

Syntax:

ISBLANK(Reference)

Description:

Returns TRUE if the specified cell is empty.

Example:

If A1 contains any kind of value, C7 is empty:

ISBLANK(A1) returns FALSE

ISBLANK(C7) returns TRUE

See also:

ISNA, IFEMPTY, COUNT, COUNTA