How to use ISBLANK Function in Excel

The Excel ISBLANK function returns TRUE when a cell contains is empty, and FALSE when a cell is not empty. For example, if A1 contains “apple”, ISBLANK(A1) returns FALSE

Syntax:= ISBLANK (value)

The ISBLANK function syntax has the following arguments:

  • Value (required argument) is the value that we wish to test. (This function takes in a cell)

Example: Let’s look at some Excel ISBLANK function examples and explore how to use the ISBLANK function as a worksheet function in Microsoft Excel:

The spreadsheet below shows examples of the Excel Isblank function, used to determine whether a cell is empty or not.

ISBLANK Function - How to use ISBLANK Function in Excel

Syntax:  =ISBLANK(A2)

Result:

ISBLANK Function in Excel - How to use ISBLANK Function in Excel

Based on the Excel spreadsheet above, the following ISBLANK examples would return:

Syntax: =ISBLANK(A3)
Result: FALSE

Syntax: =ISBLANK(A4)
Result: TRUE

Syntax: =ISBLANK(A5)
Result:FALSE

Syntax: =ISBLANK(A6)
Result: FALSE

Syntax: =ISBLANK(A7)
Result: FALSE

Syntax: =ISBLANK(A8)
Result: FALSE

Note:

Use the ISBLANK function to test if a cell is empty or not.

For example, =ISBLANK(A1) will return TRUE if A1 is empty, and FALSE if A1 contains text a formula (even if the formula returns an empty string “”).

It’s probably best to think of ISBLANK to mean “is empty” since it can return FALSE when cells look blank but aren’t. For example, if A1 contains a space character (” “), or a formula that returns an empty string (“”), A1 will look blank , but ISBLANK(A1) will return FALSE in both cases.

Add a Comment

Your email address will not be published. Required fields are marked *