ISBLANK

The ISBLANK function checks if the cell is empty.

Returns TRUE if it is and FALSE if it contains any data (including spaces, hidden characters and empty strings).

This can be useful for processing data and performing various operations depending on the presence or absence of values.

Syntax

ISBLANK(value)

Argument	Description	Permitted values
value	Reference to a cell, the value of which needs to be checked	Reference to a cell

Examples of use

Checking whether a cell is empty

=ISBLANK(A1)

If cell A1 is empty, the function returns TRUE; if it contains data, it returns FALSE.

Using the function in a condition

=IF(ISBLANK(A1), "Cell is empty", "Cell contains data")

This formula will check whether cell A1 is empty and return the corresponding message.

Checking multiple cells

=AND(ISBLANK(A1), ISBLANK(B1))

This formula will check whether cell A1 is empty and return the corresponding message.

Notes

The ISBLANK function returns FALSE if the cell in the value argument contains any data, including spaces or hidden characters.