Check if a Cell is Blank

Excel Formulas › Information

All versionsISBLANKIF

To act on whether a cell is empty — show “missing,” hold a calculation until data arrives — use ISBLANK inside IF. One subtlety trips everyone: a formula returning "" is not blank to ISBLANK.

Quick formula: to label A2 as filled or missing:
=IF(ISBLANK(A2), "Missing", "OK")
ISBLANK returns TRUE only for a truly empty cell; IF then returns your chosen labels.

Functions used (tap for the full reference guide):

ISBLANKIFCOUNTBLANK

The example

Flag the rows with a missing value.

AB
1ValueStatus
242OK
3Missing
417OK

The formula

The status in B2:

=IF(ISBLANK(A2), "Missing", "OK") // empty cell → Missing

How it works

ISBLANK is a strict empty test:

  1. ISBLANK(A2) returns TRUE only when A2 holds nothing at all — no value, no formula.
  2. IF then returns “Missing” for empty cells and “OK” otherwise.
  3. A cell with a formula that outputs "" is not blank to ISBLANK — it contains a formula. Use =A2="" if you want to treat "" as empty too.

Hold a calculation until a cell is filled: =IF(A2="", "", A2*B2) shows nothing until both inputs exist — cleaner than a sheet full of zeros or errors.

Try it: interactive demo

Live demo

Type a value or clear it; see the status.

Status:

Variations

Treat "" as blank too

Catches empty-string formula results:

=IF(A2="", "Missing", "OK")

Count the blanks

COUNTBLANK for a whole range:

=COUNTBLANK(A2:A100)

Do the calc only when filled

Avoid premature errors:

=IF(A2="", "", A2 * B2)

Pitfalls & errors

ISBLANK vs ="". ISBLANK is FALSE for a formula that returns "" (the cell isn’t empty, it has a formula). Use =A2="" to treat both as blank.

A space isn’t blank. A cell with one space is not empty. Clean with TRIM if stray spaces are sneaking in.

Merged cells confuse ISBLANK. Only the top-left cell of a merge holds the value; the others read as blank.

Practice workbook

📊
Download the free Check if a Cell is Blank practice workbook
A column with gaps, live ISBLANK status, the ="" and hold-the-calc variants, plus 4 challenges with answers. No sign-up required.

Frequently asked questions

How do I check if a cell is blank in Excel?
Use =IF(ISBLANK(A2), "Missing", "OK"). ISBLANK returns TRUE only for truly empty cells. To also treat formula results of "" as blank, use =A2="" instead.
Why does ISBLANK say a cell isn't blank when it looks empty?
The cell contains a formula that returns "" or an invisible character like a space. ISBLANK only sees genuinely empty cells; use =A2="" or TRIM to handle those cases.
How do I stop a formula calculating until a cell is filled?
Wrap it: =IF(A2="", "", A2*B2) returns a blank until the input exists, avoiding premature zeros or errors.

Stop fighting formulas. Learn them in a day.

This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.

See the Formulas & Functions Class

Related formulas: Count blank cells · Catch errors with IFERROR · Check if a cell has an error

Function references: ISBLANK · IF · COUNTBLANK