ISBLANK

The ISBLANK function checks if a value is empty.

Syntax

=ISBLANK(value)

Parameters

• value: The value to test

Examples

=ISBLANK("") // Returns TRUE
=ISBLANK(" ") // Returns FALSE (contains a space)
=ISBLANK(A1) // Returns TRUE if A1 is empty