Skip to main content

ISBLANK function

The ISBLANK function is one of the information functions. It is used to check if the cell is empty or not. If the cell does not contain any value, the function returns TRUE, otherwise the function returns FALSE.

Syntax​

ISBLANK(value)

The ISBLANK function has the following argument:

ArgumentDescription
valueThe value that you want to test. The value can be an empty cell, error, logical value, text, number, reference value, or a name referring to any of these.

Notes​

How to apply the ISBLANK function.

Examples​

The figure below displays the result returned by the ISBLANK function.

ISBLANK Function