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

previous-small ISBLANK Function in Excel                                                                                                          next_small ISBLANK Function in Excel