Skip to content

Excel function · Information

Excel ISBLANK function

ISBLANK returns TRUE when the cell is completely empty and FALSE when it holds anything at all: a number, 0, text, a space or a formula. Use it to flag rows with missing information.

In Turkish Excel: EBOŞSA

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

English Excel=ISBLANK(value)
Turkish Excel=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

ArgumentRequiredDescription
valueRequiredThe 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.

D2fx=ISBLANK(C2)
Flag products with no price entered: example table
ABCDE
1ItemProduct CodePricePrice Empty?Status
2NotebookKR-11042.50FALSEOK
3PenKR-120TRUEMissing
4Binder38.90FALSEMissing
5EraserKR-1600.00FALSEOK
  • 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.

E2fx=SUMPRODUCT(--ISBLANK(B2:D2))
Count how many fields are empty in each row: example table
ABCDEF
1ItemCategoryPriceSupplierMissing FieldsStatus
2NotebookStationery42.50West Paper0OK
3Pen12.00Atlas Ltd1Incomplete
4BinderStationery2Incomplete
5StaplerOffice89.90Blue Office0OK
6Eraser3Incomplete
  • 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

Type this in Nexell

In the product list, write next to each row how many of the category, price and supplier fields are empty

Convert to table

Bring 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.

Related functions

All information functions →

Stop memorising formulas. Describe them.

Bring your table into the tool and say what you need; Nexell builds the formula and shows it in a preview.

Try it free