ExcelFlux

ISBLANK function

TRUE if the value is blank.

Information

Where can you use it?

Workbook and data quality owners. Use functions that inspect cell type, errors or the calculation environment when validating a report.

Scenario in the workbook

Distinguish a truly empty cell from zero and text. A formula returning empty text still occupies its cell.

A worked example from the workbook

RowA
6Input
7—
80
9Pending
Record 1
=ISBLANK(A7)

Expected resultTRUE

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=ISBLANK(A1)
Turkish Excel · tr-TR
=EBOŞSA(A1)

Expected result

TRUE

Worked examples

Distinguish a truly empty cell from zero and text. A formula returning empty text still occupies its cell.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A
6 Input
7 —
8 0
9 Pending
Case Formula Expected result
Record 1 =ISBLANK(A7) TRUE
Record 2 =ISBLANK(A8) FALSE
Record 3 =ISBLANK(A9) FALSE
Microsoft Excel reference