How to Use ISBLANK Function in Excel (2 Examples)

Quick View of ISBLANK Function of Excel

Today I will be showing how you can check whether a cell is empty or not using the ISBLANK function of Excel.

Excel ISBLANK Function (Quick View)

Quick View of ISBLANK Function of Excel

 

Download Practice Workbook

Excel ISBLANK Function: Syntax and Argument

Summary

  • Returns TRUE if the cell reference used as the argument is blank, otherwise returns FALSE.
  • Have both Array Formula and Non-Array Formula.
  • Available from Excel 2003.

Syntax

Syntax of the ISBLANK Function

The Syntax of the ISBLANK function is:

=ISBLANK(value)

Argument

Argument Required or Optional Value
value Required The reference of the cell which you want to check is either blank or not. Can be a cell reference, text value, number or an array.

Note:

  • The argument which you want to check can be a cell reference, text value, number or an array.
  • If the argument is an array, the formula will be an Array Formula and you have to press Ctrl + Shift + Enter to enter this.

Return Value

Returns whether a value is blank or not. TRUE if the value is blank and FALSE if not.

Excel ISBLANK Function: 2 Examples

Now I will show you 3 examples of how to use the ISBLANK function in Excel formulas.

1. Deciding whether a Student was Present or Absent Using ISBLANK Function

Look at the set of data below. We have the names of some students and their marks in Physics in the Annual Examination.

Data Set of ISBLANK Function in Excel

Now we will decide for each student, using the ISBLANK function, that he was present or absent in the examination.

Enter this formula in the first cell:

=IF(ISBLANK(C4),"Absent","Present")

And then double click on the Fill Handle to fill in the rest of the cells.

ISBLANK Formula to Determine Present or Absent

Explanation of the Formula

  • ISBLANK(C4) returns a TRUE if the cell C4 is blank, and returns a FALSE if it is not.
  • IF(ISBLANK(C4),"Absent","Present") returns “Absent” if it finds a TRUE, and returns “Present” if it finds a FALSE.
  • Same for the rest of the cells.
Formula Output Explanation
=IF(ISBLANK(C4),”Absent”,”Present”) Present First returns a TRUE if the cell C4 is blank, otherwise FALSE. Then returns “Absent’ if it finds a TRUE, otherwise returns “Present”.

2. Making a List of the Absent Students (ISBLANK Array Function)

Now we will make a list of the absent students using the ISBLANK function.

The formula will be:

=FILTER(B4:B20,ISBLANK(C4:C20))

FILTER with ISBLANK Function in Excel

Explanation of the Formula

  • ISBLANK(C4:C20) returns an array of TRUE or FALSE, TRUE when it faces a number, FALSE when it faces a blank cell in the range C4 to C20.
  • FILTER(B4:B20,ISBLANK(C4:C20)) returns the name from the range B4 to B20 when it faces a TRUE.
Formula Output Explanation
=FILTER(B4:B20,ISBLANK(C4:C20)) Billy Doctrove

Peter Simpson

Richard John

John Foster

Morris Johnson

Desmond Hayes

First returns an array of TRUE or FALSE, TRUE when it faces a number, FALSE when it faces a blank cell in the range C4 to C20. Then returns the name from the range B4 to B20, when it faces a TRUE. 

Conclusion

Using these methods, you can use the ISBLANK function of Excel to determine whether a cell is blank or not. Do you have any questions? Feel free to ask us.


Further Readings

Rifat Hassan

Hello! Welcome to my profile. Here I will be posting articles related to Microsoft Excel. I am a passionate Electrical Engineer holding a Bachelor’s degree in Electrical and Electronic Engineering from Bangladesh University of Engineering and Technology. Besides academic studies, I always love to keep pace with the revolution in technology that the world is rushing towards day by day. I am diligent, career-oriented, and ready to cherish knowledge throughout my life.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo