Skip to main content
Skip table of contents

GTE (>=)

Category: Logical functions

Overview

Description

If 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 when you need a 1/0 flag to mark where one input is greater than or equal to another.

Syntax

  • GTE('Node1', 'Node2')

  • 'Node1' >= 'Node2'

Parameters

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

  • Node2: 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

Year

Value

2025

400

2026

700

2027

850

2028

500

Input node: B

Year

Value

2025

350

2026

400

2027

850

2028

600

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

Year

→ GTE Result

2025

1

2026

1

2027

1

2028

0


Related Functions

Function

When to use instead

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.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.