Explanation
ISBLANK function checks if a cell is empty. If it is blank, it returns TRUE, otherwise, it returns FALSE.
The ISBLANK function is usually combined with an IF function, in order to check if a certain cell is blank, and perform a different calculation accordingly.
For example, let’s ask Excel to check if a certain cell is empty, and in case it is – returns “The cell is empty”. Otherwise, returns “This cell is not empty”:
Note that we don’t need to type “=TRUE” after the ISBLANK formula, as it’s the default condition that is checked.
Please remember that if there’s even one whitespace in the cell – it will not be considered blank!
Syntax
The syntax of ISBLANK is:
=ISBLANK(value)
value – The cell that we want to check if blank or not. If it’s blank, the result will be TRUE, if it’s not blank the result will be FALSE.
Practice ISBLANK
Okay, now let’s practice the ISBLANK function!