Skip to main content
๐Ÿ“Œ More functions: see the Formula function reference.

โ€‹
1 Basics

ISBLANK is a common spreadsheet function (Excel, Google Sheets) โ€” checks if a cell is empty. Returns TRUE when the cell is empty; FALSE when it contains anything (including empty strings, formula results, etc.).

โ€‹
Syntax

formula
ISBLANK(value)
  • value: the cell or expression to check.

โ€‹
Examples

โ€‹
Example 1: empty check

[Field 1] in the first record has no content.
formula
=ISBLANK([Field 1])
Result: TRUE

โ€‹
Example 2: cell with text

[Field 1] in the first record contains โ€œHelloโ€.
formula
=ISBLANK([Field 1])
Result: FALSE