# ISBLANK function in Excel

> ISBLANK returns TRUE when a cell is completely empty.

Source: https://spreadsheetpractice.com/functions/isblank · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** ISBLANK returns TRUE when a cell is completely empty.
- **Syntax:** `=ISBLANK(value)`
- **Most common use:** `=IF(ISBLANK(B3),"Needs owner","Assigned")` returns Needs owner (Book venue has no owner yet)
- **Available in:** Every current version
- **Category:** [Information functions](https://spreadsheetpractice.com/functions/category/info)
- **Returns:** TRUE if the cell is empty, FALSE otherwise.
- **Google Sheets:** Available in Google Sheets with the same argument.

## What it does

ISBLANK returns TRUE when a cell is completely empty. Use it inside IF to flag missing owners, dates or amounts before they quietly turn into zeros in your totals. It is strict: a cell holding a formula that returns "" is not blank.

## Syntax

`=ISBLANK(value)`

| Argument | Required? | What it is |
|---|---|---|
| `value` | Required | The cell to test. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| E2 | `=IF(ISBLANK(B3),"Needs owner","Assigned")` | Needs owner | Book venue has no owner yet |
| F2 | `=SUMPRODUCT(--ISBLANK(B2:B5))` | 2 | Counts the empty owner cells |
| G2 | `=IF(OR(ISBLANK(B4),ISBLANK(C4)),"Incomplete","Complete")` | Incomplete | Send invites is missing a due date |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D | E | F | G |
|---|---|---|---|---|---|---|---|
| 1 | Task | Owner | Due |  | Row 3 owner | Tasks with no owner | Row 4 check |
| 2 | Draft budget | Ana | 3/2/2026 |  | Needs owner | 2 | Incomplete |
| 3 | Book venue |  | 3/5/2026 |  |  |  |  |
| 4 | Send invites | Lee |  |  |  |  |  |
| 5 | Order catering |  | 3/9/2026 |  |  |  |  |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| FALSE for a cell that looks empty | The cell holds a formula that returns "" or a stray space. ISBLANK is only TRUE for truly empty cells. Test =B2="" instead, or =LEN(TRIM(B2))=0 to catch spaces too. |
| A list of TRUE and FALSE instead of a count | =ISBLANK(B2:B50) tests each cell. To count, use COUNTBLANK(B2:B50) or SUMPRODUCT(--ISBLANK(B2:B50)). |

## Tips

- Use it in conditional formatting, =ISBLANK($B2), to highlight every row with a missing owner.

## Related functions

- [COUNTBLANK](https://spreadsheetpractice.com/functions/countblank): COUNTBLANK counts the empty cells in a range: unassigned tasks, unanswered questions, missing dates.
- [IF](https://spreadsheetpractice.com/functions/if): IF checks a condition and returns one value when it is true and another when it is false.
- [ISNUMBER](https://spreadsheetpractice.com/functions/isnumber): ISNUMBER returns TRUE when a value is a real number, which includes dates and times.

## Questions

### How do I check if a cell is empty in Excel?

=ISBLANK(A2) is TRUE for an empty cell. =A2="" is TRUE for empty cells and for formulas that return "", which is often what you actually want.

### What is the difference between ISBLANK and COUNTBLANK?

ISBLANK tests one value and is FALSE for formulas that return "". COUNTBLANK counts cells in a range and counts those "" cells as blank.

## Practice

A graded ISBLANK exercise ("Flag missing emails") is on [the ISBLANK page](https://spreadsheetpractice.com/functions/isblank). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
