ISBLANK in Excel

ISBLANK Function in Excel (Table of Contents)

• ISBLANK in Excel
• ISBLANK Formula in Excel
• How to Use the ISBLANK Function in Excel?

ISBLANK in Excel

ISBLANK Excel function is categorized as Information function. Information functions are those functions that help to determine the type of data stored within a cell. ISBLANK in excel helps to determine whether a cell is empty. It always returns a Boolean value either TRUE or FALSE, depending on whether a cell contains a value or empty. If a cell contains a value it returns FALSE and if a cell is empty it returns TRUE. It is categorized in a list of IS function in Excel. ISBLANK function checks the empty or null values.

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.

ISBLANK in Excel Example #1

Cell A6 is empty and doesn’t have any value, so ISBLANK in excel returned a TRUE value. 

ISBLANK in Excel 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 ISBLANK in excel 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”)

If returns value using ISBLANK in Excel when value is true then the last name is not provided else the last name is provided.

Applying ISBLANK formula to rest of the cells we have,

Output: 

ISBLANK in Excel 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 the conditional formatting and ISBLANK function.

We will select the range from B2:H11 and then under Home tab we will select the conditional formatting (Home -> Styles -> Conditional Formatting)

Then we will select the New Rule and a window will pop up 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:

ISBLANK in Excel 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 in excel returns a FALSE value it returns TRUE only when a cell is completely 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, ISBLANK in Excel returned TRUE value hence it is an empty cell and other cells have some hence ISBLANK in excel returns FALSE value for them.

Output:

If a cell have an empty string (“”), ISBLANK function in excel will return FALSE, as they are not blank. 

ISBLANK in Excel 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 item 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 SKU code 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:

 

You can download this ISBLANK Function in Excel template here – ISBLANK Function Excel Template

Recommended Articles

This has been a guide to ISBLANK in Excel. Here we discuss the ISBLANK Formula in excel and how to use ISBLANK function in Excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

• VLOOKUP Formula
• Remove (Delete) Blank Rows
• Highlight Row in Excel
• FIND in Excel
• ISERROR in Excel
• QUARTILE Excel Function
• Integer in Excel
• LARGE in Excel