Excel ISBLANK Function: Syntax, Examples and Tips

Q: Can ISBLANK check several cells at once?

Yes, inside an array-aware function: SUMPRODUCT(--ISBLANK(A2:A100)) counts the blanks. In Excel 365, ISBLANK(A2:A100) spills a column of TRUE/FALSE values.

Part of the free Module 5: Excel Formulas and Functions · Function 43 of 105 · Full Excel course

The Excel ISBLANK function tests whether a cell is truly empty and returns TRUE if it is, FALSE if it contains anything at all, including a formula that displays nothing. ISBLANK in Excel is used to stop calculations running on unfilled rows, to flag missing data and to build conditional-formatting rules that highlight gaps.

Table of Contents

ISBLANK syntax

=ISBLANK(value)

Arguments

Argument	Required	Meaning
value	Required	The cell to test. Usually a single reference; in Excel 365 a range returns an array of TRUE/FALSE results.

“Blank” means the cell has never had content or has been cleared with Delete. A cell holding a space, an apostrophe, or a formula such as =”” is not blank to ISBLANK.

Step-by-step example

=ISBLANK(B5)

Excel inspects B5.
If B5 has no value, formula or even a stray space, ISBLANK returns TRUE.
Type 20 into B5 and the result changes to FALSE. Type a formula that returns “” and the result is also FALSE, because the cell now contains a formula.

Practical use cases

1. Show a label for missing entries

=IF(ISBLANK(B8), "Blank", "Not Blank")

2. Suppress calculations until data is entered

=IF(ISBLANK(C2), "", C2*D2)

3. Highlight required cells that are still empty

=ISBLANK($B2)

Use as a conditional-formatting rule on the input column.

4. Count blanks in a range

=SUMPRODUCT(--ISBLANK(A2:A100))
=COUNTBLANK(A2:A100)

COUNTBLANK is simpler and, unlike ISBLANK, also counts cells whose formula returns “”.

5. Treat “looks empty” as empty

=LEN(TRIM(A2))=0

This catches real blanks, empty strings and cells containing only spaces, which ISBLANK misses.

6. Reverse the test

=NOT(ISBLANK(A2))
=A2<>""

The second form is shorter and also treats =”” results as empty.

Common mistakes and errors

FALSE on a cell that looks empty – it contains a space, a non-printing character or a formula returning “”. Use LEN(TRIM(A2))=0 or A2=”” instead.
Imported data – CSV and web imports often leave empty strings. Clean with Find and Replace or use the LEN test.
Testing text values – ISBLANK(“”) returns FALSE because the argument is a text string, not a cell reference.
Whole-range test in older Excel – ISBLANK(A2:A100) in a single cell evaluates only the cell on the same row unless wrapped in SUMPRODUCT.
Confusing with ISNONTEXT – ISNONTEXT also returns TRUE for blanks, but for numbers and errors too.

Tips and best practices

Decide what “blank” means for your data before choosing a test: ISBLANK for never-filled cells, A2=”” for formulas returning empty text, LEN(TRIM(A2))=0 for spaces too.
Clean imports once with Find and Replace (replace a single space with nothing) or Power Query so ISBLANK behaves predictably.
Use COUNTBLANK for totals and ISBLANK for row-level logic.
Guard calculations early in a row with IF(ISBLANK(key), “”, …) so half-entered rows do not show misleading results.
Highlight required fields with a conditional-formatting rule based on ISBLANK to speed up data entry.

Related functions

ISNUMBER, ISTEXT and ISNONTEXT – other data-type tests.
IF – acts on the TRUE/FALSE result.
COUNTIF – COUNTIF(range, “”) counts blanks and empty strings together.
NOT – for “is not blank” tests.
Browse the Excel Formulas hub or watch videos on YouTube.com/@PKAnExcelExpert.

Frequently asked questions

Why does ISBLANK return FALSE for a cell that looks empty?

The cell contains something invisible: a space, an apostrophe, or a formula that returns an empty string. ISBLANK only returns TRUE for cells with no content at all. Use LEN(TRIM(A2))=0 to treat those cases as blank.

Can ISBLANK check several cells at once?

Yes, inside an array-aware function: SUMPRODUCT(–ISBLANK(A2:A100)) counts the blanks. In Excel 365, ISBLANK(A2:A100) spills a column of TRUE/FALSE values.