<< Click to Display Table of Contents >> ISNUMBER (is numeric?)

Syntax:

ISNUMBER(Cell)

Description:

This returns TRUE if the given cell contains a number.

Dates are also considered as numbers, whereas logical values (TRUE and FALSE) are not.

Example:

If the cells A1 to A4 contain the values:

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

Then 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