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:

Where value argument is the value to be tested.

 

Example of ISBLANK Function in Excel:

Formula

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

Result: