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