Description
The ISNUMBER
function tests where a value has a numeric type and is not blank.
Syntax
ISNUMBER(value)
Argument | Required | Description |
---|---|---|
value | Yes | The value you wish to test is numeric. |
Result
TRUE
if the value has a numeric type and is not blankFALSE
if the value does not have a numeric type or is not blank
Examples
The ISNUMBER
function checks first and foremost the type of the value. Applying ISNUMBER
to a text value will always evaluate to FALSE
, even if there is a number in the text.
Expression | Result | Notes |
---|---|---|
ISNUMBER(3.4) |
TRUE |
|
ISNUMBER("Bob") |
FALSE |
"Bob" has a text type, not numeric. |
ISNUMBER(TRUE) |
FALSE |
TRUE is a value with a logical type, not numeric type |
ISNUMBER(42) |
TRUE |
|
ISNUMBER("42") |
FALSE |
Whenever you use quotes, the result has a type of text, not numberic |
ISNUMBER(1/0) |
FALSE |
Dividing by zero results in a blank numeric value |
ISNUMBER(0) |
TRUE |
|
ISNUMBER(-1) |
TRUE |