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. An undefined value is treated as the number 0 in the comparison; it does not force the result to false. GTE(undefined, -100) returns 1, and two undefined cells compare as 0 >= 0, which is also 1.

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.

Examples

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')

Related

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.