Excel ISBLANK Function

HomeExcel Functions List (Top 100) Examples + Sample FileExcel ISBLANK Function (Example + Sample File)

What is EXCEL ISBLANK FUNCTION

The Excel ISBLANK Function is listed under Microsoft Excel's Information Functions category. It returns TRUE if a cell is blank. In simple words, with ISBLANK function you can refer to a cell and check if they are blank or not and if it’s blank then it returns TRUE.

How to use it

To learn how to use the ISBLANK function in Excel, you need to understand its syntax and arguments:

Syntax

ISBLANK(value)

Arguments

  • value: A cell or a value that you want to test.

Notes

  • ISERROR verifies an error in both of the conditions, either that error is in absolute value or as a result of another formula.
  • It will evaluate all types of errors from a cell. #N/A, #DIV/0!, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!.

Example

To master the ISBLANK function we need to try it out in an example, so make sure to check out the below one:

In the below example, we have used ISBLANK with IF to deliver a message to the user if cell F1 is blank.

Related functions

This tutorial is the part of our Excel Functions with Examples (Function Guide) and below are some of the related functions:

About the Author

Puneet Gogia

Puneet is using Excel since his college days. He helped thousands of people to understand the power of the spreadsheets and learn Microsoft Excel. You can find him online, tweeting about Excel, on a running track, or sometimes hiking up a mountain.