GT

The GT function in Google Sheets is an operator function that returns TRUE if the first argument is strictly greater than the second, and FALSE otherwise. It's equivalent to the > operator and is mainly useful when a function reference is needed instead of an inline symbol. Dive into our comprehensive guide to master its application.

Parameters

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

Step-by-Step Tutorial

1. Using GT to compare two numbers:

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

2. Using GT with cell references:

   • Example: If A1 is 10 and B1 is 20, then =GT(A1, B1) will return FALSE.

Use Cases and Scenarios

1. Data Comparison: Compare sales figures between two periods to flag growth.
2. Grades Comparison: Identify students with scores higher than a threshold.
3. Budgeting: Determine if expenses exceed a certain limit.

Related Functions

• GTE: Returns TRUE if the first argument is greater than or equal to the second.
• LT: Returns TRUE if the first argument is strictly less than the second.
• EQ: Returns TRUE if two values are equal.

Related Articles

• Top 4 Basic Arithmetic Functions Every Google Sheets User Should Know