The Excel ISBLANK Function

Related Functions:

Function 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 spreadsheet below shows examples of the Excel Isblank function, used to determine whether a cell is empty or not.

  A B
1 10 =ISBLANK( A1 )
2 text =ISBLANK( A2 )
3   =ISBLANK( A3 )
  A B
1 10 FALSE
2 text FALSE
3   TRUE

For further details and examples of the Excel 'Is' functions, see the Microsoft Office website.