ISNUMBER

Returns TRUE if the value is a number (not a text containing digits), FALSE otherwise

Usage

ISNUMBER(value)

Parameters

value

(Required) The value to check

Examples

Example With these variables Result

ISNUMBER(123)

(None)

TRUE

ISNUMBER(val)

val is -12.3

TRUE

ISNUMBER(val)

val is "-12.3"

FALSE

ISNUMBER(val)

val is "Canada"

FALSE

ISNUMBER(val)

val is "123abc"

FALSE

More information

A text containing digits may look like a number, but it is not considered a number, so it will be refused by functions that expect a number.

See also