ISBLANK

Definition: ISBLANK is a function that returns TRUE if a cell is empty, and FALSE if it contains any value, including zero or a formula that returns an empty string.

Syntax: =ISBLANK(value)

Situation: This formula is appropriate when you need to check if a cell is empty.

Example: If you want to check if cell A1 is empty, the formula =ISBLANK(A1) will return TRUE if it is empty, and FALSE if it contains any value.