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:
- Text Concatenation Operators
- Formula Operators
- Arithmetic Operators
- 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 Name||Operator Type||Operator Symbol||Condition of the Operator|
|Greater than||Comparison Operator||>||Is 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 Name||Comparison Operators Symbol|
|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.
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”.
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: Formula for the “GT” Function
Alternatively, the syntax for the “GT” function will be:
=GT(value 1, value 2)
=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.
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.
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: