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
TRUEif the value has a numeric type and is not blankFALSEif 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 |