LTE (<=)

In Logical functions

The LTE function checks whether the matching row on the first input is less than or equal to the matching row in the second input; true (1) is returned, false (0) otherwise. Undefined values are treated as false (0).

Use this function when you need a 1/0 flag to mark where one input is less than or equal to another.

Parameters

Node1Node referenceRequired

First input node, specified using the node name in single quotes (e.g. 'Profit').

Node2Node referenceRequired

Second input node.

Example

Checking whether one input is less than or equal to another

This example compares two input nodes row by row. The result returns 1 where the first input is less than or equal to the second and 0 otherwise.

Input node: 'A'

Input node: 'B'

Formula: LTE('A', 'B')

See also

LT (<)

When equality should not count as a match and the first input must be strictly less.

GTE (>=)

When you need to check the opposite direction and include equality for values that are greater than or equal.