Skip to content

ISBLANK

InformationExcel 2007

TRUE if a cell is truly empty.

Syntax

ISBLANK(value)

Examples

=IF(ISBLANK(A2), "—", A2)

→

Good to know

  • A cell holding "" (from a formula) is not blank — test =A2="" for that too.

Related functions

COUNTBLANKISNUMBERN

More Information functions

CELLERROR.TYPEINFOISERRISERRORISEVENISFORMULAISLOGICALISNAISNONTEXTISNUMBERISODD

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.