How to Use the ISBLANK Function in Google Sheets

By Tomosuke Hasegawa · Updated Oct 29, 2026 · Beginner · 5 min read · includes 2 free exercises

In short: ISBLANK returns TRUE if a cell is empty and FALSE if it has any content. The formula is =ISBLANK(value). It is most often used inside IF.

What ISBLANK does

ISBLANK checks one cell and answers TRUE or FALSE. To count empty cells in a range, use COUNTBLANK. ISBLANK is for deciding what to do with a single cell, such as showing a warning when a required field is missing.

ISBLANK syntax

=ISBLANK(value)

The argument is a reference to the cell to check. It returns TRUE if the cell is empty and FALSE if it contains data. Google's help page adds an important caveat: a cell containing an empty string "", a space or a hidden character returns FALSE, because ISBLANK returns FALSE if the cell has any content at all. If you get an unexpected FALSE, clear the cell again to remove hidden characters.

A step-by-step example

Cell A2 holds a name and cell A3 is empty.

A
1Name
2Ann
3
=ISBLANK(A3)

This returns TRUE, because A3 has nothing in it. =ISBLANK(A2) returns FALSE.

Use it inside IF

Pair it with IF to turn the result into words:

=IF(ISBLANK(A3), "Missing", "OK")

This returns Missing. Google's page shows a similar pattern, IF(ISBLANK(B1),,A1/B1), which skips a division when the divisor cell is empty.

Common mistakes

Try it yourself

Use the cells above (A2 and A3). Type your formula into the box, starting with =, then press Check.

Exercise 1: Is it empty?

Write a formula that returns TRUE if A3 is empty.

Hint: pass the cell reference.

Exercise 2: Missing or OK

Write a formula that shows Missing if A3 is empty and OK if it is not.

Hint: ISBLANK goes inside IF.

What to learn next

Syntax and rules in this guide were checked against Google's ISBLANK help page. See all guides.