Greater Than Comparison Operators in Google Sheets “>”

In this article, I am going to talk about the greater than operator in Google Sheets, its usefulness and how you can use it.

The greater than comparison operator symbol in Google Sheets is: “>”

Let us get started then!

To begin with, let me tell you what exactly is the feature greater than “>” in Google Sheets.

The greater than is an comparison operator in math and spreadsheets; which lets you decide on the type of calculation you want to make. There are articles available in TeqTog that describe what operators are, but, I am going to tell you a little bit about them here.  

Operators: A Brief

Operators are determining factors that identify the type of calculation you wish to perform on a set of values. There are primarily four kinds of operators found in a spreadsheet program; which are:

  1. Text Concatenation Operators
  2. Formula Operators
  3. Arithmetic Operators
  4. Comparison Operators

To learn more about arithmetic operators and how to do math in Google Sheets; you can check out TeqTog’s “Math in Google Sheets”

The operator that I am discussing in this article falls in the comparison operator category.

Operator NameOperator TypeOperator SymbolCondition of the Operator
Greater thanComparison OperatorIs greater than the value

If you are curious to know more about the comparison operators “Equal to”, “Does Not Equal to” and “Less than in Google Sheets” in detail, then make sure to read “Does Not Equal in Google Sheets”, “Equal to in Google Sheets” and “Less than in Google Sheets” from TeqTog

All Comparison Operators

Here is the most uses six mathematical operators available in Google Sheets.

Operator NameComparison Operators Symbol
Less than
Greater than
Equal to=
Not Equal to<> 
Greater than or equal to>=
Less than or equal to<=

How to Use the Greater Than Comparison Operator in Google Sheets

As shown in my example below, I have two sets of values in two columns: Set A and Set B. From these values, I want to know which values in column A is less than the values in Column B.

How to Use the Greater Than Comparison Operator in Google Sheets

Since you can use the “<” operator or the “GT” function alternatively, to draw the same comparison; I have two columns to show you how you can use both the operator and the “GT” function.

Formula for the Greater Than “<” Operator

1. In column C, I will type in the formula for the less than operator to draw the comparisons between Set A and Set B.

The syntax for the “<” operator will be:

= IF(A2>B2, “Yes”, “No”)

By using this formula, I can check whether the value in cell A2 is higher than the value in B2. If so, it will generate the result as “Yes” and if that’s not the case, it will give me “No”.

Formula for the Greater Than “<” Operator

2. I will get the results by pressing “Enter”. Moreover, I can use “auto-fill” to get the same results for the rest of the column.

Greater Than Comparison Operators in Google Sheets “>”

Greater Than: Formula for the “GT” Function

Alternatively, the syntax for the “GT” function will be:

=GT(value 1, value 2)

and then

=IF (LT(A2,B2), “Yes”, “No”)

Then “GT” function will confirm whether the value in A2 is GREATER THAN (GT) the value in B2.

1. Similar to using the “>” operator, I will put in my formula.

Greater Than: Formula for the “GT” Function

2. Press “Enter” and apply the suggested “auto-fill” option, so that your spreadsheet will use this same formula on the rest of the values.  

results of use of “GT” Function

And that’s basically it on how to use the greater than operator in Google Sheets.  

I hope this tutorial was useful for you. Best of luck!

Read More TeqTog Google Sheets Tutorial Articles On:

How to Make a Box and Whisker Plot in Google Sheets

Google Sheets Notes Vs Comments

Microsoft Excel Vs Google Sheets

Was this article helpful?
YesNo


Related More Articles

Leave a Comment