ISBLANK Not Working on a Cell With a Formula?

Yes—this is usually expected behavior, not a problem with Excel. ISBLANK returns FALSE when a cell contains a formula, even if that formula displays nothing because its result is an empty string such as "".

Why ISBLANK returns FALSE for a formula cell

ISBLANK checks whether a cell is genuinely empty: it must contain no value and no formula. A formula is content in the cell, so the cell is not blank from Excel’s point of view. That remains true whether the formula displays a number, text, an error, or nothing visible.

For example, a formula may be designed to show an empty-looking result until another cell has data. With a status formula in A2 that returns "" when B2 is empty, A2 looks blank on the worksheet. But A2 still contains a formula, so an ISBLANK test of A2 returns FALSE. The display and the cell’s contents are different things.

This distinction matters in checks that control later calculations, conditional formatting, reports, and data entry. If you expect ISBLANK to detect what a person sees as an empty cell, it can appear broken. In fact, it is answering a narrower question: “Does this cell contain nothing at all?”

What ISBLANK actually checks

ISBLANK takes a cell reference and returns TRUE only when the referenced cell is empty. A cell containing a formula is not empty, even if the formula’s displayed result has zero characters. A cell containing a space is not empty either, nor is a cell containing zero or a value hidden by formatting.

These cases can look alike on screen but behave differently:

Truly empty: Nothing has been entered in the cell; ISBLANK returns TRUE.
Formula returning an empty string: The formula is present, so ISBLANK returns FALSE.
A space or other character: The cell contains text, so ISBLANK returns FALSE even if the character is hard to see.
Zero or another value formatted to look empty: The cell is not empty, so ISBLANK returns FALSE.

For a basic test, assume A2 is the cell you want to inspect and enter the check in another cell. The formula is =ISBLANK(A2). If A2 contains a formula that returns "", the result is FALSE. If A2 has been cleared completely, the result is TRUE.

Choose a test based on what “blank” means

There is no single best replacement for ISBLANK. Choose the test that matches the decision your spreadsheet needs to make. If you want to treat both a truly empty cell and a formula result of "" as having no visible value, compare the cell with an empty string.

Assume A2 is the cell being checked. The formula =A2="" returns TRUE for a genuinely empty cell and for a formula result that is an empty string. It returns FALSE for ordinary text and numbers, including zero. This is often the simplest test for formulas that should act as though a not-yet-completed answer is missing.

If you specifically need to identify a formula cell that displays an empty string, combine the empty-string comparison with ISBLANK. Assume A2 is the cell being checked; use =AND(A2="",NOT(ISBLANK(A2))). This returns TRUE when A2 compares equal to an empty string but is not truly empty. It can therefore detect a formula-generated empty string, rather than a cleared cell.

For a test that counts characters, use LEN. With A2 as the cell being checked, =LEN(A2)=0 returns TRUE when A2 contains no characters, including when it is genuinely empty or its formula returns "". It returns FALSE for a space because a space is one character. Like other formula comparisons, this does not mean the cell itself is physically empty.

For a whole range, COUNTBLANK can be useful: Excel counts both genuinely empty cells and cells whose formulas return empty text as blank for this function. That counting behavior is different from ISBLANK’s test of one cell. When the distinction matters, verify the definition you want before using a count as a data-quality measure.

Build formulas that handle empty-looking results

A common design is to leave a result visually empty until an input is supplied. For example, suppose B2 contains an optional input and A2 should remain visually empty until B2 has something to show. With that layout, a formula in A2 can be =IF(B2="","",B2*2). When B2 is empty or evaluates as an empty string, A2 displays nothing; otherwise, it displays twice the input.

Because A2 contains that formula at all times, a separate ISBLANK check of A2 will return FALSE even while A2 looks empty. If the next calculation should treat A2’s empty-string result as missing, test A2="" rather than using ISBLANK. For example, an IF formula can use that comparison to select a fallback result or skip a calculation.

This choice also affects downstream formulas. A function receiving "" may treat it differently from a truly empty cell, and some functions handle empty cells, text, and zero according to their own rules. Do not assume that “looks blank” means every formula will behave as though the cell had been cleared. Test the exact downstream calculation with representative inputs.

Be careful when changing a formula to return zero instead of an empty string, or the reverse. Zero is a numeric value, not a blank. It may be meaningful data, such as a quantity or balance, and should not be hidden or excluded merely to make a report look cleaner unless that is the intended logic.

Find spaces and other invisible characters

If a cell that appears blank makes both ISBLANK and an empty-string comparison return FALSE, it may contain a space, a nonbreaking space, or another invisible character. Spaces often arrive through pasted data, web pages, exports, or formulas that add text separators. Clicking the cell and looking at the formula bar can help, but a single space is easy to miss.

For ordinary spaces at the start or end of text, TRIM can help. With A2 as the cell to inspect, =LEN(TRIM(A2))=0 returns TRUE if removing ordinary spaces leaves no characters. It also treats an empty cell and an empty-string result as having zero trimmed characters. TRIM does not remove every kind of whitespace, so this check is not a universal cleanup tool.

Copied text may include a nonbreaking space, which TRIM does not remove. If that is the likely cause, assume A2 holds the text and use =LEN(TRIM(SUBSTITUTE(A2,CHAR(160)," ")))=0. SUBSTITUTE changes nonbreaking spaces to ordinary spaces, after which TRIM removes them. This is a targeted test, not proof that every unusual character has been removed; imported data can contain other nonprinting characters too.

Also consider errors. If the referenced cell contains an error value, a comparison or text operation may itself return an error rather than TRUE or FALSE. Decide whether an error should be reported, handled separately, or deliberately converted to another result. Hiding errors without understanding their source can make missing or invalid data harder to spot.

Use the right test in conditional formatting

Conditional formatting can make the same issue visible. A rule based on blank cells may not treat a formula cell displaying "" like a cell that has been cleared, because the formula is still present. If the intended meaning of blank is “the result is an empty string,” create a formula-based rule instead of relying on the built-in blank-cell condition.

In Excel for Microsoft 365 on Windows, select the cells to format, then choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. If the first cell in the selected range is A2, enter =A2="" and choose a format. Excel adjusts the reference for other cells in the selected range when it applies the rule. Check that the formula refers to the top-left cell of the selection; a mismatched reference can make the highlighting appear inconsistent.

If you instead want to highlight only truly empty cells, use ISBLANK in the formula-based rule. With A2 as the top-left cell in the selected range, enter =ISBLANK(A2). The distinction is useful in an input form: one rule can flag cells that users have never filled in, while another can identify formula outputs that currently have no visible result.

The same formula logic applies in Excel for Mac, though the ribbon layout can vary slightly by release. Excel for the web also supports conditional formatting, but the available rule-editing controls may differ from the desktop app. The key is the condition itself: use ISBLANK for truly empty cells and an empty-string comparison for cells that should be treated as visually empty.

Common reasons the result still seems wrong

First, check the exact cell reference. If the test points to a neighboring cell, or a copied formula changed a relative reference, the result can be correct for the wrong cell. Select the formula cell and inspect the reference in the formula bar. If a reference must stay fixed while copying, use an absolute reference such as $A$2 in the formula.

Second, distinguish a blank-looking value from hidden content. A custom number format, white font, or a narrow column can conceal a value without removing it. A formula bar inspection or a length test can help identify text that is not apparent in the grid. Formatting changes how content appears; it does not make a populated cell genuinely empty.

Third, consider whether a formula has recalculated. Excel normally recalculates formulas automatically, but a workbook set to manual calculation can display an outdated result until recalculation occurs. In Excel for Microsoft 365 on Windows, check Formulas > Calculation Options and select Automatic if that is appropriate for the workbook. Recalculation can update the displayed result, but it does not change the rule that a cell containing a formula is not blank.

Finally, confirm what the formula is returning. An IF formula might return a space, zero, or an error instead of "". Those outcomes can look similar in a formatted worksheet but are not equivalent. Check the formula’s branches and test each condition with a sample input, especially if the result feeds a report or another formula.

Frequently Asked Questions

Does ISBLANK return TRUE for a formula that returns empty text?
No. The cell contains a formula, so ISBLANK returns FALSE even if the formula displays "". Use an empty-string comparison when you want to treat that result like a blank.

What formula checks whether a cell is blank or returns an empty string?
Assuming A2 is the cell to check, use =A2="". It returns TRUE for a truly empty cell and for a formula result of "". It does not identify which of those two cases applies.

How can I tell a truly empty cell from a formula returning nothing?
Assuming A2 is the cell to check, use =AND(A2="",NOT(ISBLANK(A2))) to flag an empty-string result in a cell that is not truly empty. ISBLANK on its own distinguishes the truly empty case by returning TRUE.

Does a cell containing a space count as blank?
No. A space is text, so ISBLANK returns FALSE, and a comparison with an empty string also returns FALSE. TRIM can remove ordinary spaces for a check, but it does not remove every possible whitespace character.

Why does COUNTBLANK give a different answer from ISBLANK?
They answer different questions. ISBLANK tests whether one cell is genuinely empty; COUNTBLANK counts cells Excel treats as blank for that function, including formula results that return empty text. A formula cell can therefore make ISBLANK return FALSE while contributing to a COUNTBLANK result.

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.