ISBLANK Function in Excel: Is the Cell Truly Empty?

📎 This article includes 1 downloadable practice file ↓

InformationLevel: BeginnerAvailable in: Excel 2007+

In this article

1. Syntax
2. Examples
3. Example 1
4. Example 2
5. ISBLANK in practice
6. Where you will use it
7. Worked example
8. Mistakes people make
9. Related functions
10. Continue learning

ISBLANK returns TRUE only for truly empty cells. A formula returning “” is not blank to ISBLANK — a common surprise.

Syntax

=ISBLANK(value)

Argument	What it means
value	Usually a cell reference.

Examples

Example 1

=IF(ISBLANK(C2), "Missing", "")

Flag empty mandatory fields.

Example 2

=C2=""

TRUE for empty cells and for formulas returning “” — often what you actually want.

ISBLANK in practice

Where you will use it

• Check whether a required field is filled
• Show a reminder until a value is entered
• Conditional formatting for empty cells

Worked example

Entry	Formula	Result
Ravi	=ISBLANK(A2)	FALSE
(blank)	=ISBLANK(A3)	TRUE
0	=ISBLANK(A4)	FALSE

Results calculated in Excel.

Mistakes people make

Mistake	What to do instead
Cells with "" from formulas	ISBLANK returns FALSE; use =A2="" instead
Cells with spaces	Clean with TRIM; a space is not blank

Related functions

COUNTBLANK · ISNUMBER · IF

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Continue learning

All Information guides →

ISOMITTED Function in Excel: Was an Optional Argument Left Out?LogicalLevel: ExpertAvailable in: Excel 365 / 2021+ISOMITTED is used inside LAMBDA to give optional…N Function in Excel: Turn a Value Into a NumberN returns numbers unchanged, TRUE as 1 and text as 0. Its oddest use…ISNONTEXT Function in Excel: Anything But TextISNONTEXT is TRUE for numbers, blanks, errors and logicals. Handy in data validation to…TYPE Function in Excel: What Kind of Value Is This?InformationLevel: IntermediateAvailable in: Excel 2007+TYPE returns 1 number, 2 text, 4 logical, 16 error…

📎 Practice files for this article

• 📗
  Practice workbook: Information (IS…) functions15 tasks on realistic sales data — type your formula, the Check column turns green when it is right. Answers sheet included.
  ⬇ XLSX · 34 KB

Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.