ISBLANK Function in Excel – Test whether the cell is blank

ISBLANK Function in Excel tests if a specified cell is blank (empty) and if so, returns TRUE, if not the function returns FALSE.

Syntax of ISBLANK Function in Excel:

ISBLANK(value)

Where value argument is the value to be tested.

Example of ISBLANK Function in Excel:

Formula

ISBLANK Function in Excel 1

Only the Empty cells are considered blank by ISBLANK Function
Even the Cells with double quotes (“”) or single quotes(’’) are not considered blank

Result:

ISBLANK Function in Excel 2