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.