ISNUMBER (is numeric?)

<< Click to Display Table of Contents >>

ISNUMBER (is numeric?)

Syntax:

ISNUMBER(Value)

Description:

Returns TRUE if the specified value is a number.

Dates are considered as numbers as well, whereas logical values are not.

Example:

If the cells A1 to A4 contain the values:

"Text", 42, 09/25/2018 and TRUE

The following applies:

ISNUMBER(A1) returns FALSE

ISNUMBER(A2) returns TRUE

ISNUMBER(A3) returns TRUE

ISNUMBER(A4) returns FALSE

See also:

ISNUMBERP, ISLOGICAL, ISTEXT, ISNONTEXT, ISREF, COUNT