Excel ISBLANK Function

ISBLANK checks whether a cell is completely empty and returns TRUE or FALSE. There's no partial credit here: a cell with a single space, a formula that evaluates to nothing, or an invisible character all count as "not blank" as far as ISBLANK is concerned, even though they look empty on screen.

Syntax

=ISBLANK(value)

Parameter	Required	Description
value	Yes	The cell you want to test. Almost always a single cell reference like A2, not a range and not a typed-in value.

Basic Example

You're building a timesheet tracker where column C holds each employee's clock-in time. Column D flags any row that's missing an entry.

=ISBLANK(C2)

// C2 = the clock-in cell you're checking

If C2 has nothing in it, this returns TRUE. If it contains a time, a zero, or even a stray space someone typed by accident, it returns FALSE. That last part trips people up constantly: a visually empty cell isn't automatically a blank cell to Excel.

How ISBLANK Works

ISBLANK tests one cell, not a range

Feed it a single cell reference and you get a single TRUE or FALSE. Feed it a range like C2:C50 directly in a cell and, in current Excel 365, it evaluates only the first cell unless you're using it inside another function designed to iterate, like SUMPRODUCT or an array formula. Don't expect it to scan an entire column on its own.

Only cells with zero content return TRUE

A cell qualifies as blank to ISBLANK only if it has never held anything: no value, no formula, no space, no character of any kind. Delete a cell's contents with the Delete key and ISBLANK returns TRUE. Type a single space and clear the visible text, and it returns FALSE, because that space is still there.

A formula result is never "blank," even if the formula returns an empty string

This is the single most common ISBLANK surprise. A cell containing =IF(A2<>"", A2, "") looks empty when A2 is blank, because the formula returns "". But ISBLANK checks the cell's content, not its displayed result. Since the cell contains a formula, ISBLANK returns FALSE, full stop, regardless of what that formula calculates to.

ISBLANK ignores formatting, but not content

White text on a white background looks blank. Hidden rows look blank. Neither fools ISBLANK, because it's reading the cell's actual content, not how it renders. The reverse also holds: a cell that genuinely has nothing in it returns TRUE even if conditional formatting has painted it a solid color.

Does ISBLANK work with dynamic array spill ranges?

Yes, but only cell by cell. If a formula in B2 spills results down to B2:B10, testing =ISBLANK(B5) checks whether B5 is part of that spill and populated, which it will be as long as the spill is active. If you delete the source formula and the spill collapses, the previously spilled cells go back to being truly empty, and ISBLANK on them returns TRUE. There's no built-in way to test an entire spill range for blanks in one call. You'd need =SUMPRODUCT(--ISBLANK(B2:B10))=0 or similar to check the whole block.

Common Use Cases

Flagging incomplete records

Add a helper column that marks any row missing a required field, like a missing due date on a project tracker.

=IF(ISBLANK(D2), "Missing date", "OK")   // D2 = due date cell

Preventing errors before a calculation runs

Stop a formula from running on empty input, rather than showing an error further down the sheet.

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

// B2      = the price cell being taxed
// 1.08    = tax multiplier, only applied when B2 actually has a value

Validating imported data before you build reports on it

Data pulled from a database or CSV import sometimes carries zero-length strings instead of true blanks. Use ISBLANK alongside LEN to tell the two apart.

=IF(LEN(A2)=0, "Empty (formula or import)", "Has content")

Handling Errors

ISBLANK almost never throws an error itself. It's built to accept any single cell reference and return TRUE or FALSE, even if that cell contains an error value like #N/A (in which case ISBLANK correctly returns FALSE, since the cell has content, just content that happens to be an error).

The one place #REF! shows up is when the reference itself breaks:

Common causes of #REF!:

• The referenced cell or entire sheet was deleted after the formula was written
• A formula was copied and the relative reference shifted outside the worksheet's bounds
• A named range used inside the ISBLANK call was deleted

=IFERROR(ISBLANK(A2), "Reference error")

Notes & Gotchas

Why does ISBLANK return FALSE when a cell looks empty?

The most common reason is a formula returning an empty string. Excel stores a formula cell as containing a formula object, even when that formula calculates to "", so the cell's content type is "formula," not "nothing." ISBLANK checks content type, not the rendered result, which is why it returns FALSE even when the cell visually shows nothing. The same logic applies to a cell holding a lone space or a non-breaking space pasted from a webpage: the character is there, even if you can't see it.

What Is a Truly Blank Cell in Excel?

A truly blank cell has never held any content at all: no formula, no zero-length string, no space, no non-printing character like a line feed or non-breaking space. It's a cell in its original, never-touched state, or one that's been cleared with Delete rather than overwritten with an empty-looking value. This is the only condition under which ISBLANK returns TRUE.

What's the difference between ISBLANK and checking for <>""?

A2<>"" tests the cell's displayed result, so it returns FALSE (meaning "not blank" fails, i.e., it treats the cell as blank) for both truly empty cells and cells where a formula returns an empty string. ISBLANK(A2) is stricter: it only returns TRUE for cells with zero content, and treats any formula-driven cell as non-blank regardless of its output. If you're checking whether a formula result looks empty, use <>"" or LEN()=0. If you need to know whether a cell has ever held anything, use ISBLANK.

How do I check if a cell is not blank in Excel?

Wrap ISBLANK in NOT, or just use the not-equal operator directly. =NOT(ISBLANK(A2)) returns TRUE when A2 has any content at all, including formulas and zero-length strings. =A2<>"" returns TRUE when the cell's displayed result is anything other than empty text, which is a slightly looser test and the one most people actually want for form validation.

Can I use VBA to handle non-blank cells?

Yes. VBA has its own equivalent, IsEmpty, which behaves like ISBLANK on a cell's .Value property.

If Not IsEmpty(Range("C2")) Then
    ' cell has content, run your logic here
End If

For a whole range, loop through cells or use Application.WorksheetFunction.CountBlank to get a count in one line, which avoids looping entirely for large ranges.

Related Functions

Function	Use this when...
IF	You want ISBLANK to trigger a custom message or calculation instead of just returning TRUE/FALSE.
IFERROR	You want to catch any error a formula throws and replace it with a fallback value.