ISBLANK returns TRUE if a cell is completely empty and FALSE if it contains any value, including a formula that returns an empty string. Use it to detect missing data before calculations or reports.
=ISBLANK(value)What does ISBLANK do?
The ISBLANK function is a simple information function that checks whether a cell is truly empty. It returns TRUE when the referenced cell contains nothing at all, and FALSE when the cell holds a number, text, date, error, or even a formula that returns an empty string. This distinction matters because Excel treats an empty cell differently from a cell containing a zero-length string.
Why does this matter for everyday work? Missing data can quietly break totals, skew averages, or cause lookup formulas to return the wrong result. ISBLANK lets you build checks that flag blank entries before they cause problems, so you can clean data, validate forms, or conditionally format incomplete records.
A common situation: you receive a monthly sales report and need to know which regions have not submitted figures yet. Instead of scanning rows manually, you can use ISBLANK in a helper column to mark every empty sales cell, then filter or count those rows. The function is small but saves time and prevents mistakes.
When to use ISBLANK
- Flagging missing values in a data entry sheet before running totals or averages.
- Counting how many cells in a range are still empty with SUMPRODUCT or COUNTIF.
- Conditionally formatting blank cells so they stand out for follow-up.
- Building data validation checks that warn when required fields are left empty.
- Preventing formulas from calculating on incomplete rows by wrapping them in IF(ISBLANK(...)).
- Comparing truly empty cells with cells that contain formulas returning empty strings.
ISBLANK syntax
=ISBLANK(value)| Argument | Required? | What to enter |
|---|---|---|
value | Required | The cell reference or value you want to test. Enter a cell like B2 or a direct value like "". If you pass a range, ISBLANK only evaluates the first cell unless used inside an array formula. |
What it returns: TRUE if the value is an empty cell; FALSE if the cell contains any data, including spaces, zeros, errors, or formulas that return an empty string.
ISBLANK examples
1 Basic check for an empty cell
This example tests whether a single cell is empty. The formula =ISBLANK(B2) looks only at cell B2. Because B2 contains the number 1200, the result is FALSE. If B2 were empty, the result would be TRUE. This is the simplest way to confirm whether a specific cell has been filled in.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Value | |||
| 2 | Apples | 1200 | FALSE | ||
| 3 | Oranges | 850 | |||
| 4 | Pears | 430 | |||
| 5 | Plums | 610 | |||
| 6 |
2 Flag missing sales figures
Here you want to know whether the North region has submitted its sales figure. The formula =ISBLANK(B2) checks cell B2, which is empty in this table. Because there is no value, the function returns TRUE. You could copy this formula down a helper column to mark every region with a missing figure.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Region | Sales | |||
| 2 | North | TRUE | |||
| 3 | South | 980 | |||
| 4 | East | 1120 | |||
| 5 | West | 760 | |||
| 6 |
3 Count blank cells in a range
You can count how many cells in a range are empty by combining ISBLANK with SUMPRODUCT. The formula =SUMPRODUCT(--ISBLANK(B2:B6)) checks each cell in B2:B6. ISBLANK returns an array of TRUE and FALSE values; the double negative converts those to 1s and 0s, and SUMPRODUCT adds them. In this table only B5 is empty, so the result is 1.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Employee | Department | |||
| 2 | Alice | Finance | 1 | ||
| 3 | Bob | Sales | |||
| 4 | Carol | HR | |||
| 5 | David | ||||
| 6 | Eve | IT | |||
| 7 |
4 Detect blank cells that contain a formula returning empty text
ISBLANK returns FALSE if a cell contains a formula, even when that formula returns an empty string. In this table B2 contains a formula that returns "", so =ISBLANK(B2) returns FALSE. To test for visually empty cells, use =B2="" instead, which returns TRUE for both truly empty cells and formulas returning empty text. This example shows why understanding the difference matters when auditing data.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Product | Price | |||
| 2 | Widget | TRUE | |||
| 3 | Gadget | 25 | |||
| 4 | Doohickey | 40 | |||
| 5 | Thingamajig | 15 | |||
| 6 |
Common ISBLANK errors and how to fix them
| Error | Why it happens | How to fix it |
|---|---|---|
| #VALUE! | You passed an invalid argument type, such as a range without using an array formula, or a value that Excel cannot interpret. | Ensure the argument is a single cell reference or a literal value. For ranges, use SUMPRODUCT or an array formula. |
| #NAME? | The function name is misspelled, for example =ISBLANKK(A1). | Check the spelling: it must be exactly ISBLANK. |
| FALSE when you expected TRUE | The cell contains a formula that returns an empty string, a space, or a zero-length text value. ISBLANK only returns TRUE for completely empty cells. | Use =A1="" to test for visually empty cells, or clean the data so the cell is truly empty. |
| TRUE when you expected FALSE | The cell reference points to an empty cell, but you assumed it had data. This often happens after deleting cell contents or when referencing the wrong column. | Double-check the cell reference and confirm the cell actually contains the value you expect. |
Tips for using ISBLANK
- Use ISBLANK inside IF to replace empty cells with a default value or message.
- Combine ISBLANK with SUMPRODUCT to count blanks in a range without array entry.
- Remember that ISBLANK returns FALSE for cells containing formulas, even if the formula returns an empty string.
- Apply conditional formatting with a formula like
=ISBLANK(A1)to highlight missing entries. - When checking for visually empty cells, use
=A1=""instead of ISBLANK. - Use ISBLANK in data validation custom rules to prevent saving records with required fields left empty.
Frequently asked questions
What is the difference between ISBLANK and checking for an empty string?
ISBLANK returns TRUE only for truly empty cells. Checking =A1="" returns TRUE for empty cells and for cells containing formulas that return an empty string. Use ISBLANK when you need to know if a cell has never been filled.
Does ISBLANK work on cells with spaces?
No. A cell containing a space is not empty, so ISBLANK returns FALSE. To treat spaces as blank, use =TRIM(A1)="".
Can ISBLANK check multiple cells at once?
ISBLANK itself only evaluates one cell. To check a range, combine it with SUMPRODUCT, for example =SUMPRODUCT(--ISBLANK(A1:A10)), which counts blank cells.
Why does ISBLANK return FALSE for a cell that looks empty?
The cell likely contains a formula that returns an empty string, or it contains a space or other invisible character. Use =A1="" or =TRIM(A1)="" to test for visually empty cells.
Is ISBLANK case-sensitive?
ISBLANK does not deal with text case; it only checks for emptiness. It is not case-sensitive because it does not compare text values.
Related functions
Every example on this page was recalculated by SheetSkill’s spreadsheet engine. ISBLANK reference