Practice free

ISBLANK function

ISBLANK returns TRUE if a cell is truly empty and FALSE otherwise. A cell containing empty text or a single space is not blank, so it returns FALSE.

Example

Read it as a sentence: check whether F1 is completely empty, which gives TRUE.

Practice this in the app

Syntax

ISBLANK(value)

value (required)
The cell or value to check.

Returns: TRUE if the cell is truly empty.

What Excel actually returns

Each formula below was run in desktop Excel. The result is exactly what the cell showed, errors included.

FormulaExcel showsCase
=ISBLANK("") FALSE Empty text literal
=ISBLANK(0) FALSE Zero
=ISBLANK(Data!F1) TRUE Blank cell
=ISBLANK(Data!F8) FALSE Formula ""
=ISBLANK(Data!F7) FALSE Cell with 0
=ISBLANK(Data!F1:F3) TRUE Range spills
=ISBLANK(Data!E1) TRUE Column E blank

The Data sheet these formulas read

A cell that starts with = holds that formula.

Watch out for

  • A cell containing "" or a space is not blank.
  • Use LEN(cell)=0 to treat empty text as blank.

Where it works

Excel
ISBLANK is in every version of Excel from 2007 on.
Google Sheets
Same name, same behaviour for everyday use.

Part of Information functions. Every result on this page was measured in desktop Excel, build 16.0.20527. Last updated .