How to use the ISBLANK function in Excel

THE ISBLANK function can be used to determine if a cell is empty or not.

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: 

Enter ISBLANK to start the function

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:

In this example, we can check if cell E2 is empty

You will see that this formula will evaluate to TRUE:

Picture13png.png

Now enter a value in cell E2 and see how the result will change:

Enter data into the cell, and the function’s output changes from True to False

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:

ISBLANK can be usefully combined with other functions like IF

The above formula will evaluate to:

When combined with IF, ISBLANK can display different results if the cell is empty or not.


Now enter a value in cell E2 and you will see the cell G2 changing to:

Again, change the value in the cell to see the output of the IF/ISBLANK functions

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.

To learn more about this function, please click here.




Get More Exclusive Content

Sent Directly to your inbox with Excel 3 Tip Friday. A weekly dose of Functions shortcuts and tips for getting more out of Excel.

We won't send you spam. Unsubscribe at any time. Powered by ConvertKit