Help Centre › Functions & Formulas
For a full list of available calculation functions, please read What calculation functions are supported.
This article describes the formula syntax and usage of the ISNUMBER function and is applicable to both the RPA and Cloud Automate's calculate functions.
Description
Returns TRUE if value is a number, or FALSE if value is anything else.
Syntax
ISNUMBER(value)
The ISNUMBER function syntax has the following arguments:
- value - Required. The value to test.
Example
| Formula | Description | Result |
| =ISNUMBER(-1) | Checks whether -1 is a number | TRUE |
| =ISNUMBER(2.5) | Checks whether 2.5 is a number | TRUE |
| =ISNUMBER("text") | Checks whether "text" is a number | FALSE |
Errors
For a full list of formula errors, please read Formula errors.