ISBLANK() Function in Excel
ISBLANK function detects whether the excel cell is blank or not and respectively returns “TRUE” or “FALSE”. When the cell is blank it will return value as “TRUE”, else “FALSE”.
Isblank Excel Formula-
Examples of using ISBLANK Function in Excel
Given below are some of the examples of Isblank excel function.
We will first take a simple example of the Isblank excel formula where we will see its functioning.
Suppose we have a simple set of characters/ words in excel cells. We will apply the Isblank excel formula and whichever cell is blank will return value “TRUE” for blank cells.
Type ISBLANK excel function in Cell B2. Here we are checking what value(True/False) the formula will return.
Enter the cell value as B2 in function.
Press enter to get the answer. We can see the return value is “FALSE”.
Drag the formula to below cells.
In Cell B4 where it is blank, the value returned is TRUE as it is blank.
Suppose we have data where we have assigned some work/task to co-workers and would like to add the status as “Done” or “Pending”.
The Cell values which are blank, let’s assume they are “Pending” and not blank then “Done”. Refer the Data below, In Column C, under “Status” would like to input the value.
Here we shall also use the combination of two formulas, one is IF() and in that, we will use excel ISBLANK function as condition/Logical test. Let’s go through the “IF()” formula first.
Here in “logical_test”, we will put the “ISBLANK()” excel formula and will select a cell B2.
Input Logical_test i.e. condition, and if the condition is true then input the value you want to see if it’s true else enter the value if condition doesn’t satisfy i.e. false. If the cell value is blank, then the condition is true, then we shall get value as “Pending” as we want a blank cell to represent as a task not done, rest all the cell with values in it will be tagged as “Done”.
Press enter to get the answer.
Similarly, we shall apply the formula for all the data points by dragging the formula to other cells.
In this example using ISBLANK() for conditional formatting cells(highlight) which are blank. Below is the data from which we need to highlight the cells which are blank.
Below are the steps to highlight the cells using ISBLANK() excel function.
- Select the table in which we need to highlight the blank cells.
- In the “Home” tab, click on “Conditional Formatting” in “Styles” section, a drop-down appears as shown below, Click on “New Rule”.
- Once you click on “New Rule”, a dialog box appears and click on “Use formula to determine which cells to format”.
- In the “Edit the Rule Description” type “=ISBLANK(Select the cell range from A1 to E4). Then press the F4 key to remove the lock reference of cells as we need to apply on all the cells of the table.
- Click on “Format” button, a dialog box appears as shown below. Here click on the “Fill” tab and select the color which you want to highlight and then click on “OK”.
- Once you click on “OK”, you will see a dialog box indicating the formula and format color selected to highlight cells. Click on the “OK” button and you will see the final output.
- Below is the final output you will see, all the blank cells are highlighted as expected.
Things to Remember
- Excel ISBLANK function may not be necessary to use as we can give blank conditions in the “IF()” formula. Blank cells are indicated as double inverted commas without any character in between. Below is one example:
- Instead of using “ISBLANK()” in the “logical_test” condition, we used double inverted commas, which signifies to detect blanks in the cell. The rest of the other process remains the same.
This has been a guide to Excel ISBLANK Function. Here we use ISBLANK Excel Formula to detect whether the excel cell is blank or not and respectively returns TRUE or FALSE. You can learn more from the following articles –