Excel ISBLANK Function

Using the Excel ISBLANK Function

Excel ISBLANK Function

Summary

The Excel ISBLANK function is one of Excel's IS functions. ISBLANK checks if a cell contains any data or if it is empty. If the cell is not empty, the function returns FALSE. If the cell is empty, the function returns TRUE.

Syntax

=ISBLANK (value)

Syntax Breakdown

Value
Required. The value that is to be tested. This can be a cell or cell reference.

Usage Notes

ISBLANK will return TRUE if a cell is empty and FLASE if a cell is not empty. Users should be cautious in that the function will return FALSE when a cell appears blank, but isn't. For example, a cell with a space character or empty string (" ") will appear blank to the user, but the function will return FALSE.