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