SheetFX
≡
<< Go back to all functions

GTE

The GTE function in Google Sheets is used to determine if the first argument is greater than or equal to the second argument. It returns TRUE if the first argument is greater than or equal to the second, and FALSE otherwise. This function is equivalent to the >= operator.

Function Syntax and Parameters

Syntax: GTE(value1, value2)

Parameters:

  • value1: The first value to compare.
  • value2: The second value to compare.

Step-by-Step Tutorial

  1. Using GTE with numbers:

    • Example: =GTE(5, 3)
    • Result: TRUE

  2. Using GTE with cell references:

    • Example: If A1 has the value 10 and B1 has the value 5, then =GTE(A1, B1) will return TRUE.

Use Cases and Scenarios

  1. Data Comparison: Check if a value is greater than or equal to a specific threshold.
  2. Data Validation: Validate if a value meets a required condition.
  3. Conditional Formatting: Use GTE in conditional formatting rules to highlight cells based on certain criteria.

Related Functions

There are no directly related functions for the GTE operator.

Related Articles