The Excel ISBLANK Function

Home » Excel-Built-In-Functions » Excel-Information-Functions » Excel-Isblank-Function Search this site: Custom Search

Related Functions:  ISERROR Function ISLOGICAL Function ISNUMBER Function ISREF Function ISTEXT Function

Basic Description

The Excel Isblank function tests if a specified cell is blank (empty) and if so, returns TRUE; Otherwise the function returns FALSE.

The syntax of the function is:

Where the supplied 'value' argument is a reference to a cell.

Isblank Function Examples

The spreadsheets below show examples of the Excel Isblank function, used to determine whether a cell is empty or not. The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right: