What it does
=ISBLANK(C2) returns TRUE if nothing has been entered in C2. A cell holding 0 is not empty, and even a single space makes a cell non-empty. The result is usually used inside IF: =IF(ISBLANK(C2),"Missing","OK").
An important detail: a cell with a formula that returns empty text, such as ="", looks empty but counts as not empty for ISBLANK, because it contains a formula. To catch both truly empty cells and cells showing empty text, use the comparison C2="", which is TRUE for both. In tables filled with formulas, this difference is a common source of confusion.
To count empty cells in a range use COUNTBLANK, and to count filled cells use COUNTA. To test the opposite, that a cell is filled, use =NOT(ISBLANK(C2)) (NOT).
Syntax
=ISBLANK(value)=EBOŞSA(değer)Arguments in square brackets are optional. English Excel separates arguments with commas (,) and uses a dot for decimals; Turkish Excel uses semicolons (;) and a decimal comma. Excel shows function names in its own language when it opens the file.
Arguments
| Argument | Required | Description |
|---|---|---|
value | Required | The cell to test, e.g. C2. Usually a single cell reference. |
Examples
1Flag products with no price entered
Column D tests whether the price cell is empty. Column E says "Missing" if either the product code or the price is empty. The eraser's price was entered as 0.
=ISBLANK(C2)| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Item | Product Code | Price | Price Empty? | Status |
| 2 | Notebook | KR-110 | 42.50 | FALSE | OK |
| 3 | Pen | KR-120 | TRUE | Missing | |
| 4 | Binder | 38.90 | FALSE | Missing | |
| 5 | Eraser | KR-160 | 0.00 | FALSE | OK |
- D2 (filled down to D5)
=ISBLANK(C2) - E2 (filled down to E5)
=IF(OR(ISBLANK(B2),ISBLANK(C2)),"Missing","OK")
The pen has no price, so D3 shows TRUE. The eraser's price is 0, but the cell is not empty: FALSE. The binder is missing its product code, so its status is Missing.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
2Count how many fields are empty in each row
ISBLANK is applied to the three-field range and gives TRUE or FALSE for each cell; -- turns them into 1 and 0, and SUMPRODUCT adds them up. This example has only truly empty cells; a formula cell returning ="" would count as filled for ISBLANK.
=SUMPRODUCT(--ISBLANK(B2:D2))| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Item | Category | Price | Supplier | Missing Fields | Status |
| 2 | Notebook | Stationery | 42.50 | West Paper | 0 | OK |
| 3 | Pen | 12.00 | Atlas Ltd | 1 | Incomplete | |
| 4 | Binder | Stationery | 2 | Incomplete | ||
| 5 | Stapler | Office | 89.90 | Blue Office | 0 | OK |
| 6 | Eraser | 3 | Incomplete |
- E2 (filled down to E6)
=SUMPRODUCT(--ISBLANK(B2:D2)) - F2 (filled down to F6)
=IF(E2=0,"OK","Incomplete")
The binder is missing its price and supplier, so it has 2 missing fields; the eraser has all three empty: 3. Rows with every field filled are marked OK.
We recalculated this example in real Excel (Microsoft 365, 16.0) and compared the results: they match.
Common errors and fixes
- Empty-looking cell gives FALSE
Cause: The cell holds a space or a formula that returns
""; either makes it non-empty.Fix: Clear the cell with Delete, or test with
TRIM(C2)=""(TRIM).- Range given
Cause:
=ISBLANK(C2:C9)was put in one cell; in Microsoft 365 the result spills one value per cell, and older versions look at a single cell only.Fix: Pass a single cell; to count blanks, use COUNTBLANK.
Good to know
- To count how many fields in a row are empty:
=SUMPRODUCT(--ISBLANK(B2:D2));--turns TRUE/FALSE into 1 and 0. - To check required fields in one formula, combine the tests with OR:
=IF(OR(ISBLANK(B2),ISBLANK(C2)),"Missing","OK").
In Nexell
Get Nexell to do it from a sentence
In the product list, write next to each row how many of the category, price and supplier fields are empty
Convert to tableBring your product list into the tool and type this. Nexell adds the missing-fields column with real Excel formulas and shows it in the preview; in the downloaded file, the count drops by itself when you fill in a field.
Nexell uses AI to understand the request and builds the result with real Excel formulas; the formula may differ from the example on this page. You see a preview first and nothing changes until you press Apply; formulas stay live in the downloaded .xlsx file.
Free account · no card needed · 30 credits a month
Frequently asked questions
What is the difference between ISBLANK and comparing with ""?
ISBLANK returns TRUE only for a cell that contains nothing. C2="" is TRUE both for an empty cell and for a cell with a formula that returns empty text, such as ="". In tables built with formulas, C2="" is usually the safer test.
Why does ISBLANK return FALSE for a cell that looks empty?
The cell holds something you cannot see: a space, a formula that returns empty text, or an invisible character copied from another file. Select the cell and press Delete, or test with TRIM(C2)="" instead.