Home/Formulas/Logic/ISBLANK
Logiceasy

ISBLANK()

Returns TRUE if a cell is empty.

Syntax
fx
=ISBLANK(value)
Arguments
ArgumentDescription
valueThe reference or value to test for emptiness.
Example
fx
=ISBLANK(A1)

Paste this into Google Sheets to run it. The live playground on this site covers 24 of the 61 functions, and ISBLANK isn't one of them yet.

Common pitfalls

  • Returns FALSE on a cell containing the empty string "": only truly empty cells are "blank". To match either, test A1="".
  • Cells holding the result of a formula that returns "" are NOT blank by ISBLANK. This is the most common gotcha.
Related formulas
ISNUMBER()
Returns TRUE if a value is a number; useful for guarding numeric expressions.
ISTEXT()
Returns TRUE if a value is a text string.
IFERROR()
Returns the first argument if it isn't an error; otherwise returns the second.
Used by
ISNUMBER()
Returns TRUE if a value is a number; useful for guarding numeric expressions.
ISTEXT()
Returns TRUE if a value is a text string.
More Logic formulas →Keyboard shortcuts for Sheets →