ExcelFlux

ISNUMBER function

TRUE if the value is a number.

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

Check data types before calculating. Excel also stores dates as serial numbers.

A worked example from the workbook

RowA
6Input
742
8Pending
9—
Record 1
=ISNUMBER(A7)

Expected resultTRUE

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=ISNUMBER(42)
Turkish Excel · tr-TR
=ESAYIYSA(42)

Expected result

TRUE

Worked examples

Check data types before calculating. Excel also stores dates as serial numbers.

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 42
8 Pending
9 —
Case Formula Expected result
Record 1 =ISNUMBER(A7) TRUE
Record 2 =ISNUMBER(A8) FALSE
Record 3 =ISNUMBER(A9) FALSE
Microsoft Excel reference