ISNUMBER

Name

Is number

Description

Tests for numeric data.

Syntax

ISNUMBER(value)

Remarks

Returns 1 (True) if the value argument is or refers to a number. Returns 0 (False) if the argument is or refers to a value that is not a number.

You might want to use the ISNUMBER function to test whether cells contain numeric data before you perform mathematical operations on them, such as averaging the cells' contents.

See also ISNONTEXT and ISTEXT.

Data Type

Accepts any data. Returns numeric (boolean) data. For more information, see Data Type for Each Cell Type.

Example

ISNUMBER(R1C2)
ISNUMBER(B3)
ISNUMBER(12) = 1 (True)