How to Use ISBLANK in Excel: Syntax, Examples, and Tips

The ISBLANK function in Excel checks if a cell is empty and returns TRUE if it is blank, or FALSE if it contains any data. Use it by typing =ISBLANK(cell_reference) where cell_reference is the cell you want to test.

Syntax

The ISBLANK function has a simple syntax with one argument:

• value: The cell or value you want to check if it is blank.

It returns TRUE if the cell is empty, and FALSE if it contains any data, including spaces or formulas.

excel

=ISBLANK(value)

Example

This example shows how to use ISBLANK to check if cells A1 and A2 are empty:

excel

A1: (empty cell)
A2: Hello

B1: =ISBLANK(A1)
B2: =ISBLANK(A2)

Output

B1: TRUE
B2: FALSE

Common Pitfalls

Common mistakes when using ISBLANK include:

• Thinking cells with formulas that return empty strings ("") are blank. ISBLANK returns FALSE for these cells because they contain a formula.
• Cells with spaces or invisible characters are not blank.

To check for cells that look empty but contain formulas returning empty strings, use =A1="" instead of ISBLANK(A1).

excel

Wrong: =ISBLANK(A1)  (returns FALSE if A1 has formula returning "")
Right: =A1=""  (returns TRUE if A1 looks empty due to formula)

Quick Reference

Usage	Description
=ISBLANK(A1)	Returns TRUE if A1 is empty
=ISBLANK(B2)	Returns FALSE if B2 contains any data or formula
=A1=""	Checks if A1 is empty or contains an empty string from a formula
=NOT(ISBLANK(A1))	Returns TRUE if A1 is not empty

Key Takeaways

Use =ISBLANK(cell) to check if a cell is truly empty.

ISBLANK returns FALSE if a cell contains a formula, even if it shows empty.

To detect cells with formulas returning empty strings, compare the cell to "" instead.

Cells with spaces or invisible characters are not blank.

Combine ISBLANK with NOT() to check if a cell has any content.