ISBLANK in Excel: How It Works and When to Use It

How-to basics · Updated November 20, 2026

In Excel, ISBLANK checks whether a cell is genuinely empty and returns the logical value TRUE if it is, or FALSE if it contains anything—including a formula that displays nothing. For example, with data in A2, enter =ISBLANK(A2) in another cell to test it.

What ISBLANK checks

ISBLANK is a logical function: its result is either TRUE or FALSE, not the text “TRUE” or “FALSE.” Its argument is a cell reference, and Excel checks whether that referenced cell has no stored content. The function does not judge whether a cell looks empty on the worksheet; it checks what is actually in the cell.

This distinction matters because a cell can appear blank while containing a formula, a space, or another value. Conversely, a cell with a value may look empty because its font color matches the background, its contents are hidden by a custom number format, or its column is too narrow. ISBLANK reports on the cell’s contents, not its appearance.

The function is useful when a workflow needs to distinguish unfilled inputs from completed ones, flag missing records, or make a decision based on whether a cell has been populated. It is available in Microsoft Excel for Microsoft 365 on Windows; the function works the same way in Excel for Mac and Excel for the web.

How the function works in a worksheet

To test a cell, put the ISBLANK formula in a different cell. With a potentially empty value in A2, enter =ISBLANK(A2) in B2. If A2 is genuinely empty, B2 displays TRUE. If A2 contains a number, text, a date, a space, or a formula, B2 displays FALSE. The test cell itself must not be the cell being tested, or the formula would refer to itself and create a circular reference.

For a column of records, put the test beside the first record and copy the formula down. With entries in A2:A20 and the result beginning in B2, enter =ISBLANK(A2) in B2, then fill down. Each copied formula adjusts its reference to the corresponding row. You can also use the function inside another formula, such as IF, to return a more useful label.

With an input or status in A2, enter =IF(ISBLANK(A2),"Needs entry","Ready") in B2. If A2 is empty, B2 displays “Needs entry”; otherwise it displays “Ready.” This can make a checklist easier to scan than a column of TRUE and FALSE results. The labels are text, while ISBLANK still provides the logical test inside the formula.

Truly empty cells versus formulas that look blank

The most common source of confusion is a formula that returns an empty text string. For example, with a calculation in A2 that should show a result only when another input is present, enter =IF(B2="","",B2*2) in A2. When B2 is empty, A2 displays nothing, but A2 still contains a formula. Consequently, a separate test of A2 with ISBLANK returns FALSE.

This is often desirable: the formula cell is not missing or untouched; it contains a calculation whose current displayed result is empty. If a report should treat such a result as visually empty, use a test that checks the value returned rather than whether the cell itself has no content. With the result in A2, enter =A2="" in B2. That comparison returns TRUE if A2 is genuinely empty or evaluates to an empty string, so it answers a different question from ISBLANK.

A cell containing one or more ordinary spaces is not blank to ISBLANK. Neither is a cell containing zero, a date, or an apostrophe entered to force text. A formula that returns zero is also content, even if a number format hides the zero. When a result seems surprising, select the cell and inspect the formula bar; that often reveals whether a hidden formula or a space is responsible.

Using ISBLANK with IF and other logic

ISBLANK is commonly nested inside IF when a sheet needs to react to missing information. For instance, with an optional completion date in C2, enter =IF(ISBLANK(C2),"Open","Complete") in D2. It displays “Open” only if C2 is truly empty. If C2 contains a formula returning an empty string, D2 displays “Complete,” because ISBLANK sees the formula in C2.

When the real business rule is “show Open if the cell looks empty, including a formula result of empty text,” use a comparison instead. With the same date or formula result in C2, enter =IF(C2="","Open","Complete") in D2. Decide which rule matches the worksheet’s meaning before choosing the test. A cell that contains a formula may be logically incomplete for a user, even though it is not technically blank.

You can combine blank checks with other logical conditions, but make the criteria explicit. For example, a required field may be considered complete only when it is not blank and another field has a valid status. Avoid adding complexity before deciding how to handle spaces, formulas returning empty text, and values such as zero. Those edge cases determine whether a check reliably matches the way people enter data.

Highlighting empty cells with conditional formatting

ISBLANK can drive conditional formatting so missing entries stand out without adding a helper column. Select the cells to check, open Home > Conditional Formatting > New Rule, choose the option to use a formula to determine which cells to format, and enter the formula below. Choose a format and confirm the rule.

With A2:A20 selected and A2 the active cell, use =ISBLANK(A2) as the rule formula. Excel evaluates the reference relative to each cell in the selected range, so A3 is checked on the next row, then A4, and so on. If the selected range begins somewhere else, make the formula’s first reference match its top-left cell. A mismatched starting reference can cause the highlighting to shift by a row or column.

This rule highlights only genuinely empty cells. It will not highlight a cell containing a formula that returns an empty string or one containing spaces. For a form where those cases should also be highlighted, the conditional-formatting test needs to reflect that broader definition of “empty.” Conditional formatting changes how cells appear; it does not clear their contents or change what ISBLANK returns.

ISBLANK compared with COUNTBLANK and COUNTA

ISBLANK tests one cell at a time and returns TRUE or FALSE. COUNTBLANK counts blank cells across a range, while COUNTA counts cells that contain entries. These functions are related, but they do not define blankness in precisely the same way. In particular, COUNTBLANK counts cells containing formulas that return empty text, whereas ISBLANK returns FALSE for those formula cells.

With A2:A6 as the range being reviewed, where A2 is truly empty, A3 contains a formula returning an empty string, A4 contains a space, A5 contains zero, and A6 contains text, enter =COUNTBLANK(A2:A6) in B2. The result is 2: COUNTBLANK includes the truly empty cell and the formula result that is empty text, but not the space, zero, or text. This is useful when the goal is to count cells that Excel treats as blank for that function.

With the same A2:A6 range, enter =COUNTA(A2:A6) in B3. The result is 4: the formula cell, space, zero, and text are all counted as populated. These counts can help check a data-entry range, but they should not be treated as interchangeable substitutes for an individual ISBLANK test. Choose the function based on whether you need a per-cell logical result, a count of blank cells, or a count of populated cells.

Common problems and practical checks

If a cell looks empty but ISBLANK returns FALSE, investigate what is stored in it before changing the formula. The usual causes are a formula returning an empty string, an ordinary space, a nonprinting character, or a value hidden by formatting. Select the cell and inspect the formula bar; you can also click the cell and look at the formula bar for a visible formula or text. Pasting data from websites or other systems can introduce characters that are difficult to see.

If the issue is spaces at the beginning or end of text, Excel’s TRIM function can remove ordinary spaces from text, but it does not remove every kind of whitespace character that may be copied from another source. Nonbreaking spaces are a common example that can require a separate cleanup step. Make a copy of important source data before applying cleanup formulas or replacing values, especially if the original spacing may matter.

Another frequent issue is checking the wrong reference after copying a formula. If every row reports the same result, confirm that the reference changes as expected—for example, A2 in the first row, A3 in the next. Absolute references, such as a reference with dollar signs, stay fixed when copied; that can be useful in some formulas, but it is usually not what a row-by-row blank check needs.

Choosing the right blank test

Start by deciding what “blank” means for the task. If the requirement is that a cell contain absolutely nothing, ISBLANK is the direct choice. If a formula returning an empty string should also count as blank, a comparison with an empty string may fit better. If the task is to count blank-like cells across a range, COUNTBLANK may be appropriate, with the formula-result behavior kept in mind.

  • Use ISBLANK for a true-empty-cell test and a TRUE/FALSE result.
  • Use a comparison such as =A2="" when a truly empty cell or a formula returning empty text should satisfy the check.
  • Use COUNTBLANK to count blank cells in a range, including formula results that are empty text.
  • Clean or normalize imported text if spaces and invisible characters should not count as meaningful entries.

For a shared workbook, document the chosen rule near the input area or in instructions. That prevents someone from interpreting a formula-generated empty display as an unfilled field—or the reverse. It is also worth testing representative cases: a genuinely empty cell, a formula returning empty text, a space, zero, and ordinary text. A small test set can expose a mismatch between the formula and the intended rule before it affects a larger report.

Frequently Asked Questions

Does ISBLANK return TRUE for a formula that displays nothing?
No. A cell containing a formula is not truly empty, even if the formula returns an empty string and the cell appears blank. ISBLANK returns FALSE for that cell.

Does ISBLANK treat zero as blank?
No. Zero is a value, so ISBLANK returns FALSE. A number format can hide a zero, but changing the display does not make the cell empty.

Why does ISBLANK return FALSE for a cell that looks empty?
The cell may contain a formula, a space, an invisible character, or a value hidden by formatting. Inspect the formula bar and consider where the data came from.

Can I use ISBLANK in conditional formatting?
Yes. Create a conditional-formatting rule based on a formula such as =ISBLANK(A2), using a reference that matches the top-left cell of the selected range. It highlights truly empty cells, not formulas returning empty text.

What is the difference between ISBLANK and COUNTBLANK?
ISBLANK returns TRUE or FALSE for a single referenced cell. COUNTBLANK returns a number for a range and also counts formulas that return empty text.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

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

Spotted an error in this guide? Let us know.