The ISBLANK function is to check whether a cell is empty. The function returns True when the cell is empty and returns false when the cell is not empty.
Formula:
= ISBLANK(value)
Explanations:
Value is required, the value to check whether it is empty or not. The function returns True when the cell is empty, or false when the cell is not empty.
Cautions:
Cells with zeros or spaces are not empty.
=ISBLANK(A1)
Cell A1 is empty, the result returns to TRUE.
=ISBLANK(A2)
Cell A2 is NOT empty, the result returns to FALSE.