ISBLANK in Excel: Examples and How It Works

How-to basics · Updated November 18, 2026

In Excel, ISBLANK checks whether a cell is genuinely empty: for example, enter =ISBLANK(A2) to return TRUE if A2 contains nothing and FALSE if it contains a value, a space, or a formula. It is useful for detecting missing entries, but a cell that looks blank is not always an empty cell.

What ISBLANK checks

ISBLANK is a logical function in Microsoft Excel for Microsoft 365 on Windows. Its result is either TRUE or FALSE. TRUE means the referenced cell has no content at all; FALSE means Excel finds something in it. That content might be a number, text, a date, a space character, or a formula—even a formula whose displayed result is an empty string.

This distinction matters when a worksheet uses formulas or formatting that make filled cells look empty. ISBLANK examines whether a cell is empty, not whether it appears empty on screen or whether its displayed value seems useful. It does not judge whether a value is correct, whether a required field has been completed properly, or whether a formula result should count as meaningful.

For example, suppose a form has a column for delivery dates. ISBLANK can flag rows where the date cell has not been entered. But if a formula has been placed in every date cell and returns an empty string until a date is available, ISBLANK will return FALSE for those formula cells. Knowing which kind of “blank” you mean helps you choose the right test.

Syntax and a basic example

The function has one argument: a cell reference. In English-language Excel, the syntax is ISBLANK(value), where value is the cell you want to inspect. For a single-cell check, place the function in a different cell so it can display its result. The function returns a logical value, not the words “empty” or “filled.”

With A2 completely empty, enter this formula in B2:

With A2 empty and B2 used for the test, the formula is =ISBLANK(A2). It returns TRUE. If you type 0, a date, or any text into A2, the same formula returns FALSE. A zero is an entered value, so it is not blank.

To show a more readable message, wrap the test in IF. With the status check in B2 and the field being checked in A2, use =IF(ISBLANK(A2),"Missing","Entered"). If A2 is truly empty, the result is Missing; if A2 contains anything, including zero, the result is Entered. The text labels are examples and can be changed to match the worksheet.

Practical ISBLANK formula examples

Here are common ways to use the function in a worksheet. In each example, the formula goes in a cell other than the cell being checked, unless the formula is being used as a conditional-formatting rule.

  • With A2 as a required input cell and B2 as the check, =IF(ISBLANK(A2),"Enter a name","") displays a reminder only while A2 is genuinely empty. After a user types a name, B2 displays nothing. The empty-string result in B2 is produced by a formula, so B2 itself is not blank.

  • With A2 and B2 as two required cells and C2 showing whether both are empty, =AND(ISBLANK(A2),ISBLANK(B2)) returns TRUE only when both cells are truly empty. If either cell contains something, it returns FALSE. This is useful for checking whether a pair of fields has been left untouched.

  • With A2:A5 as a short list to inspect and B2 used for the count, =SUMPRODUCT(--ISBLANK(A2:A5)) counts the truly empty cells in that range. For example, if A2 and A5 are empty while A3 and A4 contain entries, the result is 2. The double unary operator converts the TRUE/FALSE results into numbers that SUMPRODUCT can add.

  • With A2 as a field that can contain a genuine empty cell or a formula returning empty text, and B2 as the test, =IF(A2="","No visible value","Value shown") checks for an empty-looking result rather than only a truly empty cell. It returns No visible value for a genuinely empty A2 or one that evaluates to an empty string. Choose this kind of test when the visible result is what matters.

These formulas answer different questions. The first two use ISBLANK to test whether cells are unoccupied. The final example tests whether a cell appears to contain a value. Use the test that matches the worksheet’s purpose, rather than swapping formulas simply because both can produce a result associated with “blank.”

Why a cell can look blank but return FALSE

The most common surprise is a formula that returns an empty string. For instance, an output cell might use a formula to show a result only after an input is provided, and otherwise display nothing. The cell looks blank, but it contains a formula. Since ISBLANK checks for content, it returns FALSE.

With C2 as an input and D2 as a calculated output, enter =IF(C2=0,"",C2) in D2. If C2 is zero, D2 displays nothing. However, with D2 as the cell being checked and E2 holding the test, =ISBLANK(D2) returns FALSE because D2 still contains the IF formula. This difference often explains why a blank-count formula and a visual inspection seem not to agree.

A cell containing one or more spaces is another common cause. Spaces are text characters, even if they are difficult to see. With A2 as the cell that might contain spaces and B2 as the test, =ISBLANK(A2) returns FALSE if A2 contains a space. The same is true if the cell contains an apostrophe or other text that does not display prominently.

Formatting can also hide content. A custom number format, font color that matches the background, or a narrow column can make a value hard to notice. ISBLANK still returns FALSE because the cell has content. If a result seems inconsistent, select the cell and inspect the formula bar; that can reveal text or a formula that is not obvious in the grid.

Find cells that are empty or contain only spaces

If the goal is to treat both true blanks and ordinary spaces as empty, use a different test. With A2 as the cell to inspect and B2 as the result, =LEN(TRIM(A2))=0 returns TRUE when A2 is empty or contains only standard space characters. TRIM removes leading and trailing spaces and reduces repeated internal standard spaces; LEN then checks whether any characters remain.

This approach is broader than ISBLANK, but it is not a universal cleanup tool. Excel’s TRIM function handles ordinary space characters, not every possible whitespace character. Data pasted from a website or another system may include nonbreaking spaces or other characters that TRIM does not remove. If the test returns FALSE even though the cell appears empty, inspect the source data or use a method designed to remove the specific character involved.

Also consider whether spaces inside a legitimate entry should be preserved. A name such as “Mary Ann” contains a meaningful internal space. The LEN/TRIM test still treats that as content, as it should. If you are cleaning a column, test the formula on representative rows before using its result to change or discard data.

Use ISBLANK in conditional formatting

Conditional formatting can highlight empty cells without adding a helper formula to the worksheet. Select the cells to format, then choose Home > Conditional Formatting > New Rule > Use a formula to determine which cells to format. Enter a formula that refers to the top-left cell of the selected range, choose a format, and confirm the rule.

For a selected range A2:A20, use =ISBLANK(A2). Excel adjusts the relative reference for each cell in the range, so the rule tests A3 on the next row, then A4, and so on. To highlight blank cells across a table range A2:D20 based on each cell’s own contents, use the same top-left reference, A2. The chosen fill or font format will be applied to cells where the formula evaluates to TRUE.

Conditional formatting changes appearance; it does not fill cells or change their values. It also follows the same meaning of blank as the function: cells with formulas returning empty strings are not genuinely blank and will not be highlighted by an ISBLANK rule. If you want to highlight cells with no visible result instead, use an appropriate formula-based rule for that condition.

ISBLANK compared with COUNTBLANK and an empty-text test

ISBLANK is best for answering whether one cell is genuinely empty. COUNTBLANK is designed to count blank cells in a range, and its definition includes cells containing formulas that return empty text. That means COUNTBLANK and a count built from ISBLANK can give different totals in a worksheet with formula-generated empty strings.

With A2:A5 as the range being counted and B2 as the result cell, =COUNTBLANK(A2:A5) counts genuinely empty cells and cells whose formulas evaluate to an empty string. In contrast, the earlier SUMPRODUCT/ISBLANK approach counts truly empty cells only. If A2 and A5 are empty and A3 contains a formula returning an empty string, COUNTBLANK returns 3 while the ISBLANK-based count returns 2.

A comparison such as A2="" is useful when the question is whether a cell is empty or evaluates to empty text, rather than whether it has no content. The right choice depends on the task:

  • Use ISBLANK to find cells with no value or formula in them.

  • Use COUNTBLANK to count empty cells in a range, including formulas that return empty text.

  • Use a comparison with an empty string when you care about whether a cell has a visible text result.

Common problems and ways to troubleshoot

If ISBLANK returns FALSE unexpectedly, check the tested cell for a formula, spaces, or a hidden value. Selecting the cell and looking at the formula bar is a quick first step. You can also temporarily change the number format or widen the column if formatting might be concealing a value. Avoid deleting content until you know whether it is intentional.

If the formula displays as text instead of calculating, check that the destination cell is not formatted as Text and that the formula begins with an equals sign. Change the cell format to General if appropriate, then re-enter the formula. A leading apostrophe can also make Excel treat an entry as text rather than a formula.

If you are copying a conditional-formatting rule, confirm that its reference matches the top-left cell of the selected range. A mismatched reference may test the wrong row or column and create a pattern that looks random. In a formula placed in a normal cell, check that the reference points to the intended input cell, not to the formula’s own result cell.

Excel’s function names and argument separators can depend on language and regional settings. The examples here use English function names and commas. Some installations use semicolons between arguments, so if Excel rejects a copied formula, check the list separator used by your installation. The function logic remains the same.

Frequently Asked Questions

Does ISBLANK return TRUE for a cell containing zero?
No. Zero is a value, so ISBLANK returns FALSE. A zero may be hidden by formatting, but that does not make the cell empty.

Does ISBLANK return TRUE for a formula that displays nothing?
No. A cell containing a formula is not empty, even if that formula returns an empty string and the cell looks blank. Use COUNTBLANK or an empty-string comparison when that kind of result should count as blank.

Can ISBLANK check a whole range at once?
ISBLANK is commonly used to test an individual reference. For a count across a range, use COUNTBLANK if its treatment of formula-generated empty strings is suitable, or use a SUMPRODUCT and ISBLANK combination when you specifically need to count truly empty cells.

What is the difference between ISBLANK and COUNTBLANK?
ISBLANK returns TRUE or FALSE for a cell. COUNTBLANK returns a number for a range and counts both genuinely empty cells and cells whose formulas return empty text.

Can I use ISBLANK to highlight empty cells?
Yes. Create a formula-based conditional-formatting rule and use an ISBLANK formula referring to the top-left cell of the range. Remember that cells containing formulas are not considered blank by this rule.

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.