ISNUMBER
The following section describes the syntax and usage of the ISNUMBER function in ActivityInfo.
Description
The ISNUMBER function is used to determine whether a value is numeric - i.e. a number.
Syntax
ISNUMBER(value)
| Argument | Required | Description |
|---|---|---|
| value | Yes | The value you wish to test is numeric. |
Result
- TRUE if the value is a number.
- FALSE if the value is not a number.
Example
We will be using the ISNUMBER function to evaluate whether a value is a number, and using the IF function to return a value.
Arguments
We will be using the Quantity Field "Age" with Field code "AGE". Note the blank entry between values "21" and "18".
Formula
IF(ISNUMBER(AGE),1,0)
Results
