If(isblank excel)

The ISBLANK function is very simple and easy to use. Let us understand the working of this function with the help of some examples.

Example #1

In the table given below, the cells A2 to A5 contain values.

The ISBLANK function returns the value “false.” But the cell A6 is empty (no value).

How to not calculate (ignore formula) if cell is blank in excel

Hence, the ISBLANK function returns the value “true” (as shown in the succeeding image). 

Example #2

A list of first and last names is given in the table below. The last names of some people are not listed.

Let us identify the names that are incomplete or without the last name, using the ISBLANK function.

Now, we will understand how the formula of the ISBLANK function works. If the last name is blank, the ISBLANK function will return the value “true.” Then, using this “value” and IF function, let us check the names that are incomplete or without the last name.

The following syntax helps to identify the incomplete names.

“=IF(ISBLANK(B2),“InCompleteName”,“Complete Name”)”

When the ISBLANK returns “true;” the IF function returns “InComplete Name.” That is, the last name is not provi

how do i use isblank in excel

how to use isblank in excel formula