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