The function ISBLANK in excel is used to check if a cell is empty or not.
It will return TRUE if the cell is empty and FALSE is the cell is not empty.
The syntax for this function is as follows:
It takes one argument:value, which is the cell that you are trying to check if it is empty or not.
We can check if cell E2 is empty or not, enter the following formula in cell G2:
You will see that this formula will evaluate to TRUE:
Now enter a value in cell E2 and see how the result will change:
On its own, this function is not very useful but you can use this function as part of a formula. For example if we want to display a message in cell G2 if cell E2 is empty we would use the IF function together with the IFBLANK function as follows:
The above formula will evaluate to:
Now enter a value in cell E2 and you will see the cell G2 changing to:
Please note: if the cell contains a formula that evaluates to nothing (“”), then this cell is not empty. The ISBLANK function will return FALSE for this cell.