ISBLANK Not Working in Excel? Find the Real Cause

ISBLANK is usually working as designed: it returns TRUE only when the cell it checks has no contents. A formula that displays nothing, a space, zero, or any other value still makes the cell nonblank. With the value to check in A2, =ISBLANK(A2) tests whether A2 is genuinely empty.

What ISBLANK checks in Excel

ISBLANK is a logical function: it reports TRUE for an empty cell and FALSE when the referenced cell contains something. “Looks empty” and “is empty” are different conditions in Excel. The function checks the cell’s contents, not whether a person can see text in it.

For example, a cell containing a formula that returns an empty string is not truly empty. The formula itself is content, even if its displayed result is blank. A cell containing one or more spaces is also not empty. Neither is a cell containing 0, FALSE, or text hidden by its formatting.

By contrast, formatting alone does not make a cell nonblank. A cell with a fill color or a number format, but no value or formula, can still pass an ISBLANK test. This distinction is useful when a sheet has been formatted in advance for data entry: the empty, formatted cells are still empty for this function.

Check what is actually in the cell

Start by selecting the cell that seems blank and looking at the formula bar. If it contains a formula, text, or a number, that explains why ISBLANK returns FALSE. A formula may be easy to miss when its result is an empty string, and spaces are difficult to see in the grid.

For a quick diagnosis, place a test in an unused cell. With the cell being investigated in A2, =ISBLANK(A2) returns TRUE only if A2 has no contents. If A2 contains a formula such as one that returns an empty string, the result is FALSE. If the test itself displays an unexpected result, also check that its reference points to the cell you meant to inspect.

Formula bar shows a formula: the cell is not truly empty, even if the formula displays nothing.
Formula bar appears to show nothing: check for spaces or other characters by selecting the cell and examining its contents closely.
The cell displays a dash or blank-looking value: inspect its number format and any conditional formatting; display is not the same as stored content.
The test points somewhere unexpected: review the cell reference, especially if the formula was copied from another row or column.

Choose the test that matches your meaning of blank

ISBLANK is the right test when you specifically mean “this cell contains nothing.” In many worksheets, however, the intended question is broader: “Does this cell appear empty, including when a formula returns an empty string?” For that, compare the cell with an empty string instead. With the value being checked in A2, =A2="" returns TRUE for a genuinely empty cell and for a formula result of an empty string. It returns FALSE for a value such as zero.

That comparison is not a universal replacement for ISBLANK. It deliberately groups two cases—an actually empty cell and a formula result that looks empty—that ISBLANK distinguishes. Decide which cases your report or calculation should treat as missing before changing the test.

For example, a data-entry check might need to flag only cells that have never been filled in; ISBLANK expresses that requirement. A summary formula might need to ignore cells whose formulas return empty strings; the empty-string comparison may better match that requirement. Using the wrong definition can cause a report to count, flag, or skip records unexpectedly.

Spaces and imported text can look empty

A cell containing a regular space is not blank, and ISBLANK returns FALSE. This often happens when data is pasted from a website, exported from another system, or entered with an accidental space. TRIM can help when the unwanted content consists of ordinary spaces. With the text to inspect in A2, =LEN(TRIM(A2))=0 returns TRUE when A2 is empty or contains only ordinary spaces. It returns FALSE when meaningful text remains.

Some copied data contains a nonbreaking space, a character that looks like a regular space but is not removed by TRIM. CLEAN removes certain nonprinting ASCII characters, while SUBSTITUTE can replace the nonbreaking space represented by CHAR(160). With the potentially messy value in A2, =LEN(TRIM(CLEAN(SUBSTITUTE(A2,CHAR(160)," "))))=0 checks whether the value becomes empty after those cleanup steps.

That test is a practical cleanup check, not a guarantee that every invisible Unicode character has been removed. If it still returns FALSE, inspect the source data or clean it with a method suited to the characters involved. Be cautious about deleting spaces from meaningful text: a cleanup formula should match the data’s actual format rather than assume every unusual character is accidental.

Formulas, zeros, and formatting are different cases

Excel separates a cell’s stored contents from its appearance. A formula can return an empty string, a custom number format can hide a zero, or conditional formatting can make text hard to see. Those situations can make a cell look empty without making it empty to ISBLANK.

Zeros are especially easy to misread. A cell holding 0 is not blank, even if the worksheet is configured to hide zero values or its number format suppresses them. Likewise, a formula that calculates zero remains a formula-containing cell. If your business rule says zero means “no entry,” test for zero explicitly rather than relying on ISBLANK; zero can also be a valid measurement or result.

There is a related counting difference: COUNTBLANK counts empty cells and, in Excel, cells containing formulas that return empty text. That does not mean ISBLANK will return TRUE for those formula cells. COUNTBLANK and ISBLANK answer different questions, so a total from one function should not be treated as proof of what the other function will report.

Check references and calculation settings

A correct test can still appear wrong if it points to the wrong cell. In a formula copied down a column, a relative reference changes by row. For instance, a test copied from one row to the next may move from A2 to A3, as intended, or may shift in a way you did not expect. Click the test cell and inspect its formula bar to confirm the current reference. Use an absolute reference only when you need the reference to stay fixed as you copy the formula.

Also check that the formula was entered as a formula rather than stored as text. If the cell displays the formula characters instead of a result, it may be formatted as Text, or the formula may have been entered with a leading apostrophe. Set the cell to General, then re-enter the formula. On Windows, the ribbon path for calculation mode is Formulas > Calculation Options; choose Automatic if the workbook is set to Manual and results are not updating. Excel for Mac also has calculation settings, though their location can differ by release.

Calculation mode usually explains a stale result rather than an ISBLANK rule behaving differently. After confirming the mode, recalculate the workbook if needed and verify that the tested cell and formula reference are correct. If the referenced cell contains an error value, ISBLANK does not treat that error as empty; handle the error separately if that is part of your intended logic.

Use the right rule in conditional formatting

When the problem appears in colors or highlighting, check the conditional-formatting rule as well as the cell contents. On Excel for Microsoft 365 for Windows, select the range and go to Home > Conditional Formatting > Manage Rules to review the rule, its formula, and the range it applies to. A rule using ISBLANK will not highlight cells whose formulas return empty strings, because those cells are not truly empty.

If the desired behavior is to highlight both empty cells and formula results that display as empty, use an empty-string comparison in the rule. For a range beginning at A2, the rule formula =A2="" checks the first cell in that range; Excel adjusts the relative reference across the applied range. Confirm that the “Applies to” range starts where the formula assumes it does. If it starts on a different row, adjust the formula reference accordingly.

For a genuinely empty-only rule, ISBLANK is appropriate. If the cells may contain spaces, neither test automatically removes them; clean the source values or use a whitespace-aware formula that matches the range. On Mac, the Conditional Formatting controls are available from the Home tab, though dialog layouts can vary between versions.

Frequently Asked Questions

Why does ISBLANK return FALSE when the cell looks empty?

The cell likely contains a formula returning an empty string, one or more spaces, a zero hidden by formatting, or another value that is not visible. Select it and inspect the formula bar. ISBLANK checks contents, not appearance.

Does ISBLANK return TRUE for a formula that returns an empty string?

No. A formula in the cell means the cell is not truly empty, so ISBLANK returns FALSE. If you want to treat that result like a blank, compare the cell with an empty string instead.

How do I check whether a cell is empty or contains only spaces?

For ordinary spaces, use a LEN and TRIM test. If the source may contain nonbreaking spaces or nonprinting characters, clean those characters before testing. The right formula depends on what kinds of whitespace occur in the data.

Does ISBLANK treat zero as blank?

No. Zero is a value, so ISBLANK returns FALSE. A number format or worksheet setting may hide zero from view, but it does not remove the stored value.

Why does COUNTBLANK count a cell that ISBLANK says is not blank?

COUNTBLANK also counts cells whose formulas return empty text. ISBLANK only returns TRUE for a cell with no contents, so the functions use different definitions for this case.

In short, first decide whether “blank” means truly empty or merely empty-looking. Use ISBLANK for the first meaning, and choose an empty-string or whitespace-aware test for the second. Checking the formula bar, references, and formatting usually reveals why the result differs from what the worksheet appears to show.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Errors & fixes

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.