The Excel ISBLANK Function

Home » Excel-Built-In-Functions » Excel-Isblank-Function

Search this site:

Custom Search

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

The format of the Excel ISBLANK function is :

ISBLANK( Value )

Where the Value argument is a reference to a cell.

Examples

The following spreadsheets shows examples, of the Excel ISBLANK function being used to determine whether a cell is empty or not. The format of the function is shown in the spreadsheet on the left and the results are shown in the spreadsheet on the right :