Excel ISBLANK Not Working With Formula? Fix the Cause

Excel’s ISBLANK function returns FALSE when a cell contains a formula, even if that formula displays nothing. If you need to treat a genuinely empty cell and a formula result of an empty string alike, test the cell with an empty-string comparison instead; choose the test that matches what “blank” means in your worksheet.

What ISBLANK checks

ISBLANK checks whether a cell is empty in the underlying worksheet, not whether it looks empty on the screen. A cell is genuinely blank when nothing has been entered into it. A formula, a number, text, a space, or another stored value means the cell is not blank for this test.

For example, with A1 left completely empty, put this formula in B1. It returns TRUE because A1 contains nothing:

With A1 genuinely empty and the test in B1, enter =ISBLANK(A1). The result in B1 is TRUE.

Now enter a formula in A1 that returns an empty string. With A1 containing that formula and B1 testing A1, the result is FALSE:

With A1 containing =IF(1=1,"","value") and B1 containing the test, enter =ISBLANK(A1). The result in B1 is FALSE, although A1 appears empty.

This distinction is intentional. ISBLANK answers “Is this cell empty?” It does not answer “Does this cell display anything?” Those questions often have different answers in sheets built with formulas.

Why a formula that displays nothing is not blank

A formula can return an empty text value, often called an empty string. The formula is still stored in the cell, so ISBLANK returns FALSE. This commonly happens when a formula uses IF to show a result only when an input is available. The cell may look empty while waiting for that input, but it still contains the IF formula.

For instance, suppose B2 is blank and A2 has a formula that displays a result only when B2 has content. With that cell layout, enter this formula in A2:

With B2 empty and the formula in A2, enter =IF(B2="","",B2*2). A2 displays nothing. A test of A2 using ISBLANK returns FALSE because A2 contains the formula.

Formatting can also make a nonblank cell look empty. White font on a white background, a custom number format that hides a value, a narrow column, or conditional formatting may conceal what the cell contains. These cases are different from a formula returning an empty string, but the same principle applies: appearance alone does not establish that a cell is empty.

Choose a test that matches your goal

There is no single replacement for ISBLANK that is best in every situation. Decide whether you mean “no cell content,” “nothing displayed,” or “nothing except ordinary spaces.” Then use a test designed for that definition.

Only a truly empty cell: use ISBLANK. A formula, even one returning an empty string, should count as content.
A truly empty cell or a formula returning an empty string: compare the cell with an empty string.
Empty, empty-string, or ordinary space-only content: combine TRIM and LEN to ignore spaces at the start or end.
Count empty cells and formulas returning empty strings in a range: use COUNTBLANK.

For a simple “does this cell have a value for my next calculation?” check, an empty-string comparison is often the practical choice. With A1 either genuinely empty or containing a formula that returns an empty string, this test returns TRUE:

With the cell being checked in A1, enter =A1="". It returns TRUE when A1 is empty or evaluates to an empty string, and FALSE when A1 contains ordinary text or a number.

That result is broader than ISBLANK, by design. It does not tell you whether A1 is truly empty or contains a formula. If that distinction matters, use ISBLANK as a separate check.

Handle cells that contain spaces

A cell containing one or more spaces is not genuinely blank, so ISBLANK returns FALSE. An empty-string comparison also returns FALSE for a cell containing a space: the space is text, not an empty string. This often causes confusion when data has been pasted from another system or a user has pressed the space bar into a cell.

If ordinary spaces should count as empty, TRIM can remove leading and trailing spaces, while LEN measures the remaining text length. With the value to inspect in A1, enter:

With A1 containing only ordinary spaces, enter =LEN(TRIM(A1))=0. It returns TRUE. If A1 contains North, it returns FALSE.

TRIM also reduces repeated spaces between words to a single space; it does not erase meaningful text. So a cell containing North Office still has a nonzero length after TRIM and does not count as empty. One limitation is that TRIM does not remove every character that can look like a space. In particular, nonbreaking spaces copied from web pages may remain. If a space-only test fails on imported data, inspect the cell’s contents or clean the source data rather than assuming every blank-looking character is an ordinary space.

Count blanks in a range

If your goal is a count rather than a TRUE or FALSE test, COUNTBLANK may be more convenient. It counts genuinely empty cells and also cells containing formulas that return empty text. That behavior differs from ISBLANK and is useful for checking form completion when formula-generated empty strings should count as unanswered.

With responses in A2:A10, enter this formula in another cell:

With A2:A10 as the range to check, enter =COUNTBLANK(A2:A10). If two cells are genuinely empty and one contains a formula returning an empty string, the result is 3.

Before relying on the count, confirm what the range contains. A cell with a space is not counted as blank by COUNTBLANK. If your intended rule treats space-only entries as unanswered, clean or normalize those entries, or use a separate formula-based test suited to your data. COUNTBLANK is also not a way to identify which cells contain formulas; it reports a count according to its blank-counting behavior.

Use the right test in IF formulas

A common reason to check for blanks is to avoid showing zeros, errors, or incomplete results before someone enters an input. Choose the condition based on whether a formula-generated empty string should be treated as missing.

For example, suppose B2 holds an optional input and A2 should display “Missing” when B2 is empty or evaluates to an empty string. With B2 as the input, enter:

With the input in B2, enter =IF(B2="","Missing",B2). If B2 is empty, the result is the text Missing; if B2 contains Ready, the result is Ready.

If the distinction between a truly empty cell and a formula cell matters, test ISBLANK directly instead. With B2 as the cell being tested, enter:

With B2 containing a formula that returns an empty string, enter =IF(ISBLANK(B2),"Truly empty","Contains something"). The result is Contains something because B2 contains a formula.

Be mindful of what happens when a referenced cell contains an error. A comparison such as B2="" can return an error if B2 itself evaluates to an error, and the surrounding IF may then also show that error. The blank test does not automatically repair errors in the source formula; diagnose or handle the error separately if the sheet needs a fallback result.

Check what Excel actually has in the cell

When a result seems wrong, inspect the source cell rather than changing the test at random. Select the cell and look at the formula bar. If it shows a formula, the cell is not genuinely empty, even when the grid displays no characters. If it appears to contain text, check for invisible spaces or other imported characters.

These checks can narrow down the cause:

Select the cell and inspect the formula bar to see whether it contains a formula or value.
Temporarily test the cell with ISBLANK and with an empty-string comparison in separate cells. Different results are expected when a formula returns empty text.
Check whether the cell contains a space by editing it or comparing the results of a space-aware test.
Look for formatting that hides content, including font color, number formats, conditional formatting, and column width.
Confirm that the formula refers to the intended cell. A relative reference may shift when copied across rows or columns.

If you have just deleted a cell’s contents, a formula that refers to that cell should recalculate under Excel’s normal automatic calculation setting. If results appear stale across the workbook, check Formulas > Calculation Options and make sure Automatic is selected. Changing calculation settings affects how formulas update; it does not change what ISBLANK means.

Common misconceptions and useful distinctions

“Looks blank” and “is blank” are not interchangeable descriptions in Excel. A formula returning an empty string looks blank but contains a formula. A cell containing a space may look blank but contains text. A cell with a hidden number may look blank but still contains a number. These differences matter when validating data, counting unanswered fields, or deciding whether a later calculation should run.

Another frequent misconception is that ISBLANK can test the displayed result of a formula. It cannot; it tests whether the referenced cell is empty. For display-oriented logic, compare with an empty string. For cleaning ordinary spaces, add TRIM and LEN. For counting cells that Excel treats as blank for that purpose, use COUNTBLANK. Pick one according to the question you need answered, rather than treating the functions as interchangeable.

Frequently Asked Questions

Why does ISBLANK return FALSE when the cell looks empty?
The cell probably contains a formula returning an empty string, a space, or content hidden by formatting. ISBLANK returns TRUE only when the cell itself is empty.

What formula checks for a blank cell or a formula returning nothing?
With the cell to check in A1, enter =A1="". It returns TRUE for a genuinely empty A1 and for a formula in A1 that evaluates to an empty string.

Does COUNTBLANK count cells with formulas that return nothing?
Yes. COUNTBLANK counts genuinely empty cells and cells whose formulas return empty text. A cell containing a space is not counted as blank.

How do I make spaces count as blank?
With the cell to check in A1, enter =LEN(TRIM(A1))=0. This treats a cell containing only ordinary spaces as empty, but it may not remove nonbreaking spaces copied from some sources.

Can ISBLANK tell whether a cell displays anything?
No. It checks whether the cell is empty, not what appears on screen. Use an empty-string comparison for formulas that display nothing, and inspect formatting if a value may be hidden.

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.