GTE (>=)

In Logical functions

The GTE function checks whether the matching row on the first input is greater 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 greater 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 greater than or equal to another

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

Input node: 'A'

Input node: 'B'

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

See also

GT (>)

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

LTE (<=)

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