LESS (<)
The following section describes the syntax and usage of the LESS (<) function in ActivityInfo.
Description
The LESS (<) function is used to determine whether a certain value is less than another.
Syntax
value1 < value2
| Argument | Required | Description |
|---|---|---|
| value1 | Yes | The value you wish to test is less than another. The value must be numeric. |
| value2 | Yes | The value you wish to test against. The value must be numeric. |
Result
- TRUE if value1 is less than value2.
- FALSE if value1 is equal to or greater than value2.
Example
We will be using the LESS (<) function to test whether a given value is less than another, and using the IF function to return a value.
Arguments
We will be using the Quantity Field "Age" with Field code "AGE".
Formula
IF(AGE < 18,1,0)
Results
