ISBLANK Formula Examples in Excel

In Excel, ISBLANK checks whether a referenced cell is genuinely empty and returns TRUE or FALSE. For example, with a cell to check in A2, enter =ISBLANK(A2); it returns TRUE if A2 contains nothing, but FALSE if it contains text, a number, a space, or a formula—even one that displays an empty string.

What the ISBLANK Function Checks

ISBLANK is a logical function: its result is either TRUE or FALSE. It is useful when a worksheet needs to distinguish an unused cell from one that contains data. You might use it to flag missing information, decide whether to calculate a result, or show a prompt until a required entry is supplied.

The key is that Excel evaluates what is in the cell, not just what appears on screen. A cell can look empty while containing a formula that returns an empty string, a space character, or content hidden by formatting. ISBLANK reports FALSE for those cells because they are not truly empty.

Conversely, a cell containing the number zero is not blank. Nor is a cell with a date, a logical value, or an error value. Formatting does not change this test: a blank-looking cell with a white font or a custom number format is still not blank if it contains a value.

ISBLANK Syntax and Basic Example

The function takes one argument: the cell reference or value to test. In this example, the worksheet has a single cell to inspect, A2; the function returns TRUE only if that cell is empty.

=ISBLANK(A2)

For instance, if A2 has never been used or its contents have been cleared with Delete, the result is TRUE. If A2 contains the word Pending, the result is FALSE. The function does not need quotation marks around the reference, and it does not accept multiple arguments.

To test another cell, change the reference. For a row-by-row check, enter the formula beside the first record and fill it down. With values in A2:A20 and the check formula entered in B2, copying B2 down changes the reference for each row, so B3 checks A3 and B4 checks A4. This makes it easy to create a helper column showing which records still need information.

Practical ISBLANK Formula Examples

ISBLANK becomes more useful when paired with IF. The following examples assume an ordinary worksheet where each referenced cell has the described role.

Show a missing-entry message: with a name in A2, test whether it has been entered. The formula returns Missing when A2 is genuinely empty and Entered otherwise.

=IF(ISBLANK(A2),"Missing","Entered")
Calculate only when an input exists: with a quantity in A2 and a unit price in B2, show an empty-looking result until a quantity is entered. If A2 is empty, the formula returns an empty string; otherwise, it multiplies the quantity by the price. B2 should contain a numeric price for the calculation to work as intended.

=IF(ISBLANK(A2),"",A2*B2)
Check two required fields together: with a first required value in A2 and a second in B2, return Both missing only when both cells are truly empty. If either has an entry, the result is Check entries.

=IF(AND(ISBLANK(A2),ISBLANK(B2)),"Both missing","Check entries")
Label a date field: with a due date in A2, display Enter a date if the cell is empty. Otherwise compare the date with the current date and label it Past due or Upcoming. A2 needs to contain a real Excel date value for the comparison to be meaningful.

=IF(ISBLANK(A2),"Enter a date",IF(A2<TODAY(),"Past due","Upcoming"))

In the final example, TODAY updates when Excel recalculates, so the label can change from Upcoming to Past due as time passes. If today should count as not yet past due, use a less-than comparison as shown; a date equal to today will be labeled Upcoming.

Blank Cells, Empty Strings, and Spaces

The most common source of confusion is a formula that displays nothing. For example, the earlier IF example returns an empty string when A2 is blank, but the cell containing that IF formula is not itself empty. If you test that result cell with ISBLANK, the answer is FALSE. The cell contains a formula, even though its displayed result looks blank.

A cell containing one or more spaces is also not blank. Spaces are text characters, and they can be difficult to notice, especially if the column is wide or the font is small. If a cell appears empty but ISBLANK returns FALSE, select it and inspect the formula bar. You can also edit the cell and remove any unintended spaces or formulas.

There is an important difference between testing for a truly empty cell and testing whether a cell appears to have no visible content. A comparison with an empty string can treat a truly empty cell and a formula returning an empty string alike. In this example, A2 is the cell being checked; the result says Blank or empty string for either case, and Has visible value otherwise.

=IF(A2="","Blank or empty string","Has visible value")

Choose that comparison only when treating formula-generated empty strings as blank is appropriate. It is not identical to ISBLANK, so it can give a different answer by design. A space character is still content and will not match an empty string.

Counting Blank Cells in a Range

ISBLANK tests one reference at a time. When the goal is to count empty cells across a range, COUNTBLANK is usually more direct. Suppose A2:A6 contains a truly empty cell in A2, a formula returning an empty string in A3, the word Done in A4, an empty cell in A5, and zero in A6. The count is 3: COUNTBLANK includes the two genuinely empty cells and the formula result that displays as an empty string, but not the text or zero.

With those example entries in A2:A6, this formula returns 3.

=COUNTBLANK(A2:A6)

This difference matters when auditing a worksheet. Use ISBLANK when you need to know whether a specific cell physically has no content. Use COUNTBLANK when you want a range-level count that also treats formula results of empty strings as blank. If the count seems higher than the number of visibly empty cells, inspect the range for formulas that return empty strings.

Highlight Empty Cells with Conditional Formatting

Conditional formatting can make genuinely empty cells easier to spot without adding a helper column. In Excel for Microsoft 365 on Windows, select the range to format, then choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Set the rule to use the ISBLANK test and choose a format, such as a light fill color.

For example, suppose the selected range is A2:C20 and the first cell in that range is A2. Use this formula for the rule. Because the reference is relative, Excel adjusts it for each cell in the selected range.

=ISBLANK(A2)

Apply the rule and the fill will appear on cells in the selected range that are genuinely empty. A cell containing a formula that returns an empty string will not be highlighted by this rule. If the intent is to highlight both truly empty cells and formula results that display nothing, a rule based on a comparison with an empty string may be more suitable; confirm that behavior matches the worksheet’s purpose before applying it broadly.

The same function behavior applies in Excel for Mac, though the ribbon layout can differ slightly by release. In Excel for the web, the available formatting controls may also vary. The essential point is that a conditional-formatting formula is evaluated relative to the top-left cell of the selected range.

Common Problems and How to Diagnose Them

ISBLANK says FALSE for a cell that looks empty. Check whether the cell contains a formula returning an empty string, a space, or another invisible character. Select the cell and inspect the formula bar.
A cell with zero is not detected as blank. This is expected. Zero is a numeric value. If zero should count as missing for a particular task, use a test designed for that business rule rather than treating zero as an empty cell.
Clearing formatting does not make the test TRUE. Formatting changes appearance, not cell content. To remove content, select the cell and press Delete. On Windows, the Delete key clears cell contents; it does not necessarily remove formatting. The Mac keyboard’s Delete key behavior can depend on the keyboard, but the Clear Contents command is available from the Home tab.
A copied formula checks the wrong cell. ISBLANK references normally adjust as a formula is filled down or across. If you need to keep a reference fixed, use an absolute reference with dollar signs; if you want each row checked separately, leave the row reference relative.
A merged area gives an unexpected result. Excel stores content in the upper-left cell of a merged range. Test that cell when checking the merged area; the other cells in the merged area do not hold separate values.

When debugging, test the cell directly in an unused area of the worksheet and compare the result with what you see in the formula bar. This separates a true empty cell from one that only appears empty and helps identify whether the issue comes from the data, the reference, or the display format.

ISBLANK Compared with Other Options

ISBLANK, COUNTBLANK, and an empty-string comparison solve related but different problems. ISBLANK gives a TRUE or FALSE result for one cell and is strict about whether the cell itself is empty. COUNTBLANK summarizes a range and counts cells whose values are blank, including formula results that are empty strings. Comparing a cell with an empty string is useful when both a truly empty cell and an empty-string result should be treated as having no visible entry.

Choose the test based on what “blank” means in the worksheet. For a required input that must be physically supplied, strict ISBLANK behavior may be appropriate. For a report where a formula-produced empty string should count as no displayed answer, COUNTBLANK or an empty-string comparison may better match the intended outcome. These approaches are not interchangeable, so test them against representative rows before using them in a large report.

Frequently Asked Questions

Does ISBLANK return TRUE for a formula that displays nothing?
No. The cell contains a formula, so ISBLANK returns FALSE even if the formula’s displayed result is an empty string.

Does ISBLANK treat zero as blank?
No. Zero is a value, so the cell is not blank. Use a separate condition if zero should be handled as missing in your specific worksheet.

Why does ISBLANK return FALSE for an apparently empty cell?
The cell may contain a space, an invisible character, or a formula. Inspect the formula bar and clear unintended content; changing the cell’s formatting alone will not make it empty.

Can ISBLANK check a whole range at once?
ISBLANK takes one value or reference as its argument. For a count of blank cells in a range, COUNTBLANK is generally the straightforward choice. To check each row separately, place an ISBLANK formula beside the first row and fill it down.

What is the difference between ISBLANK and COUNTBLANK?
ISBLANK tests one cell and is TRUE only when that cell is genuinely empty. COUNTBLANK counts cells in a range and also counts formulas that return empty strings, so the results can differ when a range contains such formulas.

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.