LESS OR EQUAL (<=)
The following section describes the syntax and usage of the LESS OR EQUAL (<=) function in ActivityInfo.
Description
The LESS OR EQUAL (<=) function is used to determine whether a certain value is less than or equal to another.
Syntax
value1 <= value2
| Argument | Required | Description |
|---|---|---|
| value1 | Yes | The value you wish to test is less than or equal to 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 or equal to value2.
- FALSE if value1 is greater than value2.
Example
We will be using the LESS OR EQUAL (<=) function to test whether a given value is less than or equal to 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
