Excel ISBLANK Formula Examples and Common Mistakes

Excel’s ISBLANK formula checks whether a cell is truly empty: enter =ISBLANK(A2) to get TRUE if A2 has no contents and FALSE if it contains a value or formula. It is useful for flagging missing entries, but it does not treat a formula that displays nothing or a cell containing spaces as blank.

What ISBLANK checks

ISBLANK is a logical function: its result is either TRUE or FALSE. It takes one argument, usually a cell reference, and tests whether that referenced cell is empty. It does not judge whether the cell looks empty on screen; it checks whether Excel considers the cell to contain anything.

That distinction matters in worksheets where cells may be formatted, populated by formulas, or contain invisible characters. A cell can look blank but return FALSE because it holds a formula or a space. Conversely, a genuinely empty cell returns TRUE even if it has formatting such as a fill color or border.

TRUE: the referenced cell has no value or formula.
FALSE: it contains a number, text, a logical value, an error, or a formula—even one whose displayed result is an empty string.

ISBLANK does not change the worksheet. It reports a condition that another formula, a filter, or a formatting rule can use.

Basic ISBLANK formula examples

Assume A2 is genuinely empty. This formula returns TRUE:

=ISBLANK(A2)

Now enter the number 0 in A2. The same formula returns FALSE. Zero is a value, even if a number format hides it or a nearby formula makes it seem like the cell is unused. Text such as “Pending” also returns FALSE.

To turn the TRUE/FALSE result into a useful message, assume A2 contains an item description or is empty. This formula displays “Missing” for an empty cell and “Entered” otherwise:

=IF(ISBLANK(A2),"Missing","Entered")

The IF function checks the result of ISBLANK and returns one of its two text choices. Copy the formula down a column to check a list. If it is in B2, for example, copy it down alongside the entries in column A; each copied formula will check the corresponding row.

You can also use the test to keep a calculation cell empty until required input is present. Assume A2 contains a quantity and B2 contains a unit price. This formula in C2 displays a blank until A2 has been entered, then calculates the extended price:

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

If A2 is empty, C2 displays nothing. If A2 contains 3 and B2 contains 12, C2 returns 36. Notice that “displays nothing” describes C2’s appearance, not its contents: C2 now contains a formula.

Check more than one cell

For a row that is complete only when two fields are filled, combine ISBLANK tests with AND. Assume A2 contains a customer name and B2 contains an order number. This formula returns “Both blank” only when both cells are truly empty:

=IF(AND(ISBLANK(A2),ISBLANK(B2)),"Both blank","At least one filled")

If A2 is empty but B2 contains 104, the result is “At least one filled.” If both are empty, it is “Both blank.” For a rule that should flag a row when either field is missing, use OR instead. With the same cell layout, this formula returns “Check row” if either cell is empty:

=IF(OR(ISBLANK(A2),ISBLANK(B2)),"Check row","Complete")

Be precise about the intended rule. “Both blank” and “at least one blank” are different checks, and confusing AND with OR can produce a plausible-looking but incorrect result.

Truly empty cells versus formulas returning an empty string

A common surprise is that ISBLANK returns FALSE for a cell containing a formula that displays nothing. For example, a formula may use an empty string as its result. Assume A2 contains this formula; it displays no characters, but ISBLANK(A2) returns FALSE:

=IF(B2=0,"",B2)

The reason is that A2 contains a formula, regardless of what the formula displays. This often happens in reports that hide results until another cell has been completed. If your goal is to treat a genuinely empty cell and a formula-generated empty string alike, compare the cell with an empty string instead. Assume A2 is either truly empty or contains a formula returning an empty string. This formula returns “Blank or empty text” for either case:

=IF(A2="","Blank or empty text","Has content")

This is not identical to ISBLANK. A comparison with an empty string is useful when you care about what the cell evaluates to, while ISBLANK is the right test when you specifically need to know whether the cell contains anything at all. Choose based on how the worksheet is built.

Spaces and other invisible characters

A cell containing one or more ordinary spaces is not empty, so ISBLANK returns FALSE. Spaces can arrive through pasted data or be entered accidentally, making a cell look vacant while blank-cell checks fail. The TRIM function can help when you want to treat ordinary spaces at the edges, or repeated spaces, as no meaningful content.

Assume A2 contains only three ordinary spaces. This formula returns TRUE because TRIM removes them and LEN counts zero remaining characters:

=LEN(TRIM(A2))=0

If A2 contains “North Branch,” the formula returns FALSE because text remains after trimming. TRIM is not a universal invisible-character cleaner: for example, it does not remove every nonbreaking space that may come from copied web data. If a value still fails the check, inspect the source or clean the specific character rather than assuming the cell is truly empty.

ISBLANK compared with COUNTBLANK and COUNTA

Use ISBLANK to test one referenced cell and use COUNTBLANK when you need a count across a range. COUNTBLANK counts genuinely empty cells and also cells containing formulas that return an empty string. COUNTA counts cells with content, including cells containing formulas that display empty text. Their results can therefore differ in a worksheet that uses formulas to hide output.

Assume A2:A6 contains the word “Ready” in A2, a genuinely empty A3, a formula returning an empty string in A4, the number 5 in A5, and a space in A6. COUNTBLANK returns 2: A3 and A4 meet its blank-counting rule.

=COUNTBLANK(A2:A6)

With that same A2:A6 layout, COUNTA returns 4 because A2, A4, A5, and A6 contain entries or formulas. The apparently empty formula cell A4 counts as populated for COUNTA.

=COUNTA(A2:A6)

These functions answer different questions. For example, a completeness report may need to count cells with no displayed value, in which case COUNTBLANK can be helpful. A check for cells with no contents at all calls for ISBLANK applied to individual cells.

Highlight blank cells with conditional formatting

To visually flag missing entries, select the cells you want to check, such as A2:A20, and on Excel for Microsoft 365 for Windows choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. The formula should refer to the first cell in the selected range. With A2:A20 selected, enter:

=ISBLANK(A2)

Choose a format, such as a fill color, and confirm the rule. Excel adjusts the relative row reference as it evaluates each cell in the selected range, so A2 is checked in the first row and A3 in the next. This highlights genuinely empty cells, not cells containing formulas that return empty text. If those should also be highlighted, use a condition appropriate to that layout, such as a comparison with an empty string.

Excel for Mac also provides conditional formatting rules through the Home tab; labels and dialog layouts can vary slightly by release. Excel for the web supports conditional formatting too, although some advanced rule-editing options may differ from the desktop app. The ISBLANK function itself works in all of these Excel versions.

Common problems and how to troubleshoot them

The result is FALSE although the cell looks empty: check whether the cell contains a formula returning an empty string, a space, or another invisible character. Click the cell and inspect the formula bar.
A zero is being treated as filled: that is expected. Zero is a value. If your business rule considers zero equivalent to missing, use a different condition that explicitly checks for zero as well as blank.
Formatting changes the result: fill color, borders, and number formats do not make a cell empty. A custom format that hides a value changes its display, not its underlying contents.
The formula shows an error: make sure the reference is valid and the formula’s parentheses are balanced. ISBLANK itself takes one argument; do not provide a range if the intention is to test one cell.
A pasted blank-looking entry is not detected: pasted content may include spaces or other characters. Try selecting the cell and checking the formula bar, or use a cleaning step suited to the actual character.

When checking imported or user-entered data, first decide what “missing” means in the context of the worksheet. It may mean no cell contents, no displayed result, only spaces, or a specific placeholder such as “N/A.” One test cannot reliably cover all of those meanings without being designed for them.

Frequently Asked Questions

What does ISBLANK return in Excel?
It returns TRUE when its referenced cell is genuinely empty and FALSE when that cell contains a value or formula. A formula that displays an empty string still makes the cell nonblank to ISBLANK.

Does ISBLANK consider zero to be blank?
No. Zero is a number, so ISBLANK returns FALSE for a cell containing 0. If zero should count as missing in your particular task, add a separate zero condition rather than relying on ISBLANK alone.

How do I check whether a cell is blank but ignore formulas that show nothing?
ISBLANK is the appropriate test when you only want TRUE for a cell with no contents. A formula returning an empty string is still a formula, so ISBLANK returns FALSE for that cell.

What formula checks for a blank cell or an empty-string result?
A comparison such as A2 equals an empty string can match both a genuinely empty cell and a formula result of empty text. Use that approach when the displayed or evaluated result matters more than whether the cell contains a formula.

Can ISBLANK check an entire range at once?
ISBLANK is designed to test a cell reference. To count blank cells in a range, use COUNTBLANK; to check or highlight each cell separately, apply ISBLANK in a copied formula or a conditional formatting rule.

Choosing the right blank check

Use ISBLANK when you need to identify cells with no contents, such as a missing form entry. Use a comparison with an empty string when formula-generated blank results should count as empty too, and consider TRIM-based testing when ordinary spaces are the problem. COUNTBLANK and COUNTA are convenient for range totals, but their counting behavior around formulas differs. Matching the formula to your definition of “blank” is the key to dependable spreadsheet checks.

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

More in Formulas & functions

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

Spotted an error in this guide? Let us know.