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)

**Table of Contents**hide

**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**

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.

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.

**Explanation of the Formula**

returns a`ISBLANK(C4)`

**TRUE**if the cell**C4**is blank, and returns a**FALSE**if it is not.returns`IF(ISBLANK(C4),"Absent","Present")`

**â€ś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â€ť. |

**Similar Readings**

**How to Use ISNUMBER Function in Excel (7 Examples)****How to Use ISERROR Function in Excel (With 5 Examples)**

**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))`

**Explanation of the Formula**

returns an array of`ISBLANK(C4:C20)`

**TRUE**or**FALSE**,**TRUE**when it faces a number,**FALSE**when it faces a blank cell in the range**C4**to**C20**.returns the name from the range`FILTER(B4:B20,ISBLANK(C4:C20))`

**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.