ISNUMBER

Checks whether the specified value is numeric.

Syntax

ISNUMBER( Any x ) → Logical

Parameters

x

Required. The value to test.

Remarks

If x is a numeric value (this includes numbers, currencies, dates, times, and logical values), returns TRUE. If x is a reference to a cell, the value of the referenced cell is tested. If x is an error value, this error value is returned. In any other case, the function returns FALSE.

Example

Formula

=ISNUMBER(5.5)
=ISNUMBER(TRUE)

See Also

Function Reference
ERROR.TYPE Function
ISBLANK Function
ISERR Function
ISERROR Function
ISLOGICAL Function
ISNA Function
ISREF Function
TYPE Function