<< 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: