ISBLANK Function in Excel
ISBLANK is a logical function in excel which is also a type of referencing worksheet function which is used to refer to a cell and identify whether it has blank values in it or not, this function takes a single argument which is the cell reference and returns TRUE as output if the cell is blank and FALSE as output if cell is not blank.
ISBLANK Formula in Excel
The ISBLANK Formula in Excel is:
Value is the cell reference passed as an argument that we want to check
How to Use the ISBLANK Function in Excel?
ISBLANK function in Excel is very simple and easy to use. Let understand the working of ISBLANK function in Excel by some examples.
Example #1
Cell A6 is empty and doesn’t have any value, so it returned a TRUE value.
Example #2
We have a list of names provided with their first and last names; however, there are some names where the last name is not provided. We need to find out using excel formula the names that are incomplete or without the last name.
We can use this function to check if the last name is provided or not. If the last name is blank, the ISBLANK function will return a TRUE value; using this value and IF function, we will check whether both the names have been provided or not.
The ISBLANK formula that we will be using is
=IF(ISBLANK(B2),”InComplete Name”,”Complete Name”)
It returns a value using ISBLANK when the value is true; then, the last name is not provided else the last name is provided.
Applying the ISBLANK formula to the rest of the cells we have,
4.9 (1,353 ratings) 35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
Output:
Example #3
Suppose we have a dataset given in a range as shown below:
We want to highlight the blank cells; for example, we need to highlights cells B5, C4, and other similar blank cells in the data range.
To highlight the cells, we will use conditional formatting and ISBLANK function.
We will select the range from B2:H11 and then under the Home tab, we will select the conditional formatting in excel (Home -> Styles -> Conditional Formatting)
Then we will select the New Rule, and a window will pop up the New Formatting Rule. We will use a formula to determine the cells to format. The ISBLANK formula that we will be using is
=ISBLANK(B2:H11)
We will then select the format and will choose the highlighting color and will press OK.
Output:
Example #4
Differentiate between an empty cell and cell containing an empty string.
We have some values in column A. Range A5 contains an empty string, and A4 is an empty cell. In excel, both the cells A4 and A5 seem to be an empty cell, but we need to identify whether it is an empty cell or not.
For that, we will use the ISBLANK function and IF function to check because, for empty string, the ISBLANK function returns a FALSE value, it returns TRUE only when a cell is empty or null.
The ISBLANK formula that we will use is
=IF(ISBLANK(A2),”Is Empty”,”Not Empty”)
Applying the ISBLANK formula to other cells we have,
For cell A4, It returned TRUE value; hence it is an empty cell, and other cells have some; hence ISBLANK in excel returns the FALSE value for them.
Output:
If a cell has an empty string (“”), the ISBLANK function in excel will return FALSE, as they are not blank.
Example #5
Suppose we have a list of items with their SKU codes, and the items for which the SKU codes have not been assigned are left blank. Column A contains the list of items, and column B contains the SKU code, including the items for which the SKU codes have not been assigned. In column D, we have some list of items not arranged in order, and we need to find the SKU code, or else if the SKU code is not assigned, then we must write a formula that may return “Assign SKU Code.”
So, the ISBLANK formula that we will use to accomplish our requirement will be
=IF(ISBLANK(VLOOKUP(D2,$A$2:$B$21,2,0)),”Assign SKU Code”,VLOOKUP(D2,$A$2:$B$21,2,0))
Applying the ISBLANK formula to other cells we have,
Output:
Recommended Articles
This has been a guide to ISBLANK in Excel. Here we discuss the ISBLANK Formula in excel and how to use the ISBLANK function in Excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –
- IsEmpty in VBA
- Delete Blank Rows in Excel
- Integer in Excel
- LARGE Excel Function
- Excel Troubleshooting
- 35+ Courses
- 120+ Hours
- Full Lifetime Access
- Certificate of Completion