How to use the ISBLANK Function in Microsoft Excel?

Brief Introduction

           The Microsoft Excel ISBLANK Function returns TRUE when the cell contains not any value (empty) & returns FALSE when a cell is not empty (Having any type of value).

Purpose:

Test if a cell is empty or not.

Syntax of ISBLANK Functions:

The syntax of ISBLANK Function in Excel is as follows;

• =ISBLANK(value)

Return value:

TRUE or FALSE (Logical value)

Arguments:

• Value – To check the value of a specific cell.

You can download free the Complete Practice of Concern Topic of Microsoft Excel File, Click on the below download icon,

  

          

              This article explains in simple terms how to use ISBLANK Function during multiple criteria. It takes a step-by-step approach, & following below contents we will touch in this post.

1. Microsoft Excel ISBLANK Function explanation through various examples.

Let’s start to learn something new about the ISBLANK Function of Microsoft Excel.

1.  Microsoft Excel ISBLANK Function - Example 1.

          

        Microsoft Excel ISBLANK Function returns TRUE when a cell contains not any value (empty) & returns FALSE when a cell is not empty (Having any type of value), as we explain this function through a given below example,

Explanation: - In this example we have taken different values like Text, Numbers, Date, question marks?, percentage, empty cells & the last "C" column contains the formula that how we can use the ISBLANK Function to get our specific return. As we see that the cell "C6" contains the ISBLANK Function & "B6" is our given information, so we want to check or find out that is there the cell "B6" empty or having any value, when we use the ISBLANK Function as you see, the return is TRUE, it means that cell "B6" is empty (Blank) & having not any value, while other results are FALSE, they having some reasons, so read the note section.

In this scenario, we have used a formula like below,

=ISBLANK(B6)

Example 2.

          If in the case when we use the IF & ISBLANK Functions jointly then see their result in below example, 

Explanation: - In this example we have taken the information like Start from, End & the last "D" column contains the formula that how we can use the combo of IF & ISBLANK Functions to get our specific return. As we see that the cell "C7" contains the combo of IF & ISBLANK Functions & "B7 & C7" are our given information, so we want to check or find out that according to formula, if in column C any cell in range of "C3:C11" is empty then the answer will be TRUE, otherwise, it works according to given criteria cell "C-B", so as the selected cell "D7" return TRUE because of the cell "C7" is empty.

In this scenario, we have used a formula like below,

=IF(C7<>"", C7-B7,ISBLANK(C7))

Example 3.

  

         If in the case when we use the IF, OR & ISBLANK Functions jointly then see their result in below example,

Explanation: - In this example we have taken the information of a School result, which contains the information about ID Numbers, Student Name, Marks & the last "E" column contains the formula that how we can use the combo of IF, OR & ISBLANK Functions to get our specific return. As we see that the cell "E7" contains the combo of IF, OR & ISBLANK Functions & "B7, C7  & D7" are our given information, so we want to check or find out that according to formula, if in column C or in column D any cell in range of "C3:D11" is empty then the answer will be Fail, otherwise it return the answer as "Pass", so as the selected cell "E7" return "Fail" because the cell "D7" is empty (Qasim Ali having no Marks therefore he is Failed).

In this scenario, we have used a formula like below,

Learn MoreLearn More

=IF(OR(ISBLANK(C7),ISBLANK(D7)),"Fail","Pass")