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. The formulas are shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right:

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

Return to the Excel Information Functions Page

Return to the List of All Built-In Excel Functions

Valid XHTML 1.0 Transitional Valid CSS!
Disclaimer   Privacy Policy
Copyright © 2008-2014 ExcelFunctions.net