Excel IF ISBLANK Examples: Formulas and Fixes

To make Excel display one result when a cell is empty and another when it is not, combine IF with ISBLANK: =IF(ISBLANK(A2),"Missing","Present"). If A2 is genuinely empty, the formula returns Missing; otherwise, it returns Present. The examples below show how to adapt this pattern for messages, calculations, and cells that only look blank.

How IF and ISBLANK work together

IF tests a condition and returns one value when the condition is TRUE and another when it is FALSE. ISBLANK checks whether a referenced cell is truly empty. Its result is TRUE for an empty cell and FALSE if the cell contains a value, text, a space, or a formula—even a formula whose displayed result is an empty string.

The general structure is =IF(ISBLANK(cell),value_if_blank,value_if_not_blank). Replace cell with a reference such as A2, then supply the two outcomes. Text results need double quotation marks; numbers and cell references do not. The formula itself goes in a different cell from the one being checked, so it can display the result without replacing the input.

For example, suppose a worksheet records whether a person has submitted a form. With the submission status in A2 and the result formula in B2, an empty A2 can produce a reminder, while any entered status produces a confirmation. The formula checks the input cell, not whether the formula cell itself is empty.

Basic examples for messages and status labels

For a basic missing-value message, with a customer name expected in A2, enter this formula in another cell:

=IF(ISBLANK(A2),"Enter a customer name","Name entered")

If A2 is empty, the result is Enter a customer name. If A2 contains Jordan Lee, the result is Name entered. You can replace either message with a short status, such as To do and Complete, or with a reference to another cell that contains the message.

This pattern also works for review workflows. With the review date expected in C2, the following formula returns a reminder until someone enters a date:

=IF(ISBLANK(C2),"Review pending","Reviewed")

If C2 is empty, Excel displays Review pending. If C2 contains a date, it displays Reviewed. The formula does not verify that the date is valid for your process; it only checks whether C2 is empty. Data validation or additional tests may be needed if the entry must meet particular rules.

Use ISBLANK to control calculations

A common reason to test for a blank is to avoid showing a zero or an incomplete calculation before someone has entered the required information. Suppose A2 contains a quantity and B2 contains a unit price. Put this formula in C2 to leave the result blank until the quantity is supplied:

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

If A2 is empty, the formula returns an empty text value, so C2 looks blank. If A2 contains 4 and B2 contains 25, C2 returns 100. This is useful for keeping reports tidy, but note that the result is not a genuinely empty cell: C2 contains a formula. A formula that checks C2 with ISBLANK will therefore return FALSE.

To require both inputs before calculating, with quantity in A2 and unit price in B2, use:

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

When either input is truly empty, the result is an empty string. When A2 is 4 and B2 is 25, the result is 100. OR makes the blank test TRUE if either input is missing. If the requirement is to show a message only when both inputs are missing, use AND instead:

=IF(AND(ISBLANK(A2),ISBLANK(B2)),"Both inputs missing","Review inputs")

With both cells empty, this returns Both inputs missing. If only one is empty, it returns Review inputs. Choose OR or AND based on the rule: OR means at least one condition is true, while AND means every condition must be true.

What if a cell looks empty?

A cell that appears blank is not necessarily empty. It may contain a formula that returns an empty string, one or more spaces, or formatting that hides a value. ISBLANK distinguishes these cases from a cell that has never had content or has had its contents cleared.

Formula returning an empty string: ISBLANK returns FALSE because the cell contains a formula. This can happen with formulas designed to hide results until inputs are complete.
Space character: ISBLANK returns FALSE because a space is text, even though it can be difficult to see.
Hidden value or custom number format: ISBLANK returns FALSE if the cell still contains a value. The display format does not make the cell empty.
Cleared contents: If you remove the cell’s contents, ISBLANK returns TRUE, assuming no formula or other content remains.

If you want to treat a formula result of “” as blank too, a direct comparison can be more appropriate. With the value or formula result in A2, use:

=IF(A2="","Missing","Present")

This returns Missing when A2 is genuinely empty or when a formula in A2 returns an empty string. It does not treat a space as blank. This is a meaningful difference, not just a shorter spelling of ISBLANK.

Check several inputs and count empty cells

ISBLANK accepts a cell reference for an individual test; it does not count a range by itself. To count empty cells across a range, COUNTBLANK is the relevant function. With entries expected in A2:A20, this formula returns the number of cells Excel considers blank:

=COUNTBLANK(A2:A20)

COUNTBLANK also counts cells containing formulas that return an empty string, so its result can differ from counting cells with ISBLANK tests. That distinction matters when a column contains formulas that hide unfinished results. If you need to count only cells that are genuinely empty, an array-based approach or a helper column may be more suitable; choose it based on whether formula-generated empty strings should count.

You can also combine individual ISBLANK checks with other conditions. For example, if a report should say Ready only when both a name and a date are present, put the name in A2 and the date in B2, then use:

=IF(AND(NOT(ISBLANK(A2)),NOT(ISBLANK(B2))),"Ready","Incomplete")

The formula returns Ready when both cells contain something and Incomplete if either is empty. NOT reverses the TRUE/FALSE result from ISBLANK. This checks for presence, not quality: a space in the name cell still counts as an entry.

Common problems and practical fixes

If a result seems wrong, inspect the tested cell rather than changing the IF formula at random. Select the cell and look at the formula bar. A visible value, a leading apostrophe, a space, or a formula may explain why ISBLANK returns FALSE. To remove unwanted contents, select the cell and press Delete; on Windows, Backspace may open a clear-contents prompt in some Excel contexts, so Delete is the straightforward choice.

Other frequent issues include:

Testing the result cell: Put the IF formula in a separate cell and make sure ISBLANK refers to the input cell you intend to check.
Using the wrong quotation marks: Excel formulas require straight double quotes around text, as in “Missing”. Curly typographic quotes copied from formatted text can cause a formula error.
Expecting zero to be blank: A cell containing 0 is not blank, so ISBLANK returns FALSE. If zero should trigger a different result, test for zero explicitly rather than treating it as an empty cell.
Confusing a blank-looking result with an empty cell: Returning “” hides visible text but leaves a formula in the cell. Downstream checks should account for that.

In Microsoft 365 for Windows, enter a formula in the formula bar or directly in the selected cell and press Enter. The same formula syntax works in Excel for Mac and Excel for the web. On Mac, the Return key commonly confirms an entry; keyboard behavior can vary with settings. If a workbook uses a different list separator because of regional settings, Excel may display semicolons instead of commas in formulas.

Choosing the right blank test

Use ISBLANK when the rule is specifically about whether a cell contains anything at all. It is precise and makes the intention clear. Use a comparison with an empty string when a formula-generated “” should be treated the same as a truly empty cell. Use COUNTBLANK when you need a count across a range, bearing in mind that it counts formula results that display as empty.

For entries that may contain accidental spaces, neither ISBLANK nor a simple comparison with “” treats a space-only cell as empty. You can clean the source data, or use a more deliberate formula that removes extra spaces before testing. Be cautious with cleanup formulas: TRIM removes ordinary leading and trailing spaces and reduces repeated internal spaces, which may not be appropriate for every kind of text. A good rule is to decide what your spreadsheet means by “blank” before building reports or totals around it.

Frequently Asked Questions

What is the syntax for IF with ISBLANK in Excel?
Use IF(ISBLANK(cell), value_if_blank, value_if_not_blank), with an equals sign at the start of the complete formula. For example, the first outcome is returned when the referenced cell is genuinely empty, and the second when it contains content.

Does ISBLANK detect a formula that displays nothing?
No. A cell containing a formula is not genuinely empty, even if that formula displays an empty string. If you want to treat that result as blank, compare the cell with an empty string instead.

How do I show nothing when a cell is blank?
Use an IF formula whose blank outcome is two quotation marks with nothing between them. The displayed result will look empty, but the formula cell still contains a formula and is not itself blank.

Does ISBLANK consider zero or a space to be blank?
No. Zero is a numeric value and a space is text, so ISBLANK returns FALSE for either. Remove unwanted spaces or test explicitly for the values your worksheet should treat as missing.

Can I use ISBLANK on a whole range?
ISBLANK tests a referenced cell at a time. For a count of blank cells in a range, use COUNTBLANK. Remember that COUNTBLANK also counts cells whose formulas return an empty string.

Why does my IF ISBLANK formula show the wrong message?
The cell may contain an invisible space, a formula, or a value hidden by formatting. Check the formula bar and confirm that the ISBLANK reference points to the intended input cell.

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.