The Excel ISBLANK 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:

ISBLANK( value )

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.

 Formulas:
 AB
110=ISBLANK( A1 )
2text=ISBLANK( A2 )
3 =ISBLANK( A3 )
 Results:
 AB
110FALSE
2textFALSE
3 TRUE

Further information and examples of the Excel 'Is' functions are provided on the Microsoft Office website.