Google Sheets | LT | GT | LTE | GTE | Function | Example | Spreadsheet | Tutorial
The Google Sheets LT, GT, LTE, and GTE functions compare two values and will return either TRUE or FALSE.
The LT (less than) function is an alternative to using the less-than symbol, and the GT (greater than) function is an alternative to using the greater-than symbol. The LTE (less-than-or-equal-to) and GTE (greater-than-or-equal-to) functions are alternatives to using their respective symbols.
-------------------------------------
How to Use XMATCH in Google Sheets?
XMATCH returns the position of the specified search key in a row or column:
• Google Sheets | XMATCH | Function | Exampl...
-------------------------------------
How to Use INDEX in Google Sheets?
Get to know more about INDEX with this step-by-step video tutorial:
• Google Sheets INDEX | Use INDEX Google She...
-------------------------------------
How to Use XLOOKUP for Approximate and Wildcard Match in Google Sheets?
XLOOKUP can return approximate data and supports wildcard search:
• Google Sheets | XLOOKUP | Function | Match...
-------------------------------------
How to Use XLOOKUP to Extract Data to Left of Search Key in Google Sheets?
XLOOKUP can extract data to left, right, or left and right of search key:
• Google Sheets | XLOOKUP | Function | Get D...
-------------------------------------
How to Use XLOOKUP to Extract Multiple Values in Google Sheets?
XLOOKUP allows to extract multiple values from a row or column:
• Google Sheets | XLOOKUP | Function | Extra...
-------------------------------------
How to Use VLOOKUP in Google Sheets?
Use VLOOKUP to extract a single value to the right of the search key:
• VLOOKUP Google Sheets | How to Use VLOOKUP...
-------------------------------------
How to Use HLOOKUP in Google Sheets?
Use HLOOKUP for horizontal lookup of search key and extract a single value to its right:
• HLOOKUP Google Sheets | How to Use HLOOKUP...
----------------------------------------
How to Sum Investment Amount by Quarter?
Sum data of investments, profits, revenues, etc., by quarter:
• Google Sheets | Sum by Quarter | Example |...
-------------------------------------
How to Sum Investment Amount by Month?
The step-by-step tutorial to sum investment amount (or profits, revenues, expenses, orders, etc.) by month:
• Google Sheets | Sum Data like Investments,...
-------------------------------------
How to Sum Investment Amount by Week?
The step-by-step tutorial to sum investment amount (or profits, revenues, expenses, orders, etc.) by week:
• Google Sheets | How to Sum Investment Amo...
-------------------------------------
LT Function Formula
=LT(value1, value2)
Start the formula with an equal-to symbol.
LT is the name of the function.
value1 is the value to be tested against value2. Value1 can be, for example, a hard-coded number, a cell reference, or a formula that returns a number.
value2 is the value to be tested against value1. Like with value1, value2, can also be, for example, a hard-coded number, a cell reference, or a formula that returns a number.
Examples
Example 1
=LT(2, -6)
The function will return FALSE.
Example 2
=LT(A1, B1)
In this example, cell addresses are used as arguments instead of hard-coded values.
Example 3
=LT(SUM(A1:A10), SUM(B1:B10))
Here the SUM function is used for each of the two arguments. LT tests the numbers returned by the two SUM functions.
GT Function Formula
=GT(value1, value2)
Start the formula with an equal-to symbol.
GT is the name of the function.
value1 is the value to be tested against value2. Value1 can be, for example, a hard-coded number, a cell reference, or a formula that returns a number.
value2 is the value to be tested against value1. Like with value1, value2, can also be, for example, a hard-coded number, a cell reference, or a formula that returns a number.
Examples
Example 1
=GT(0.09, 0.3)
The function will return FALSE.
Example 2
=GT(3, C5)
In this example, a hard-coded value is tested against the value in cell C5.
Example 3
=GT(SUM(A1:A10), 239)
Here the SUM function is used for value1 argument. GT tests the number
returned by the SUM function against the number 239, which is used as value2.
LTE and GTE Function Formulas
=LTE(value1, value2)
=GTE(value1, value2)
value1 and value2 in the above formulas have the same description as that of LT or GT functions.
Example 1
=LTE(3, 3)
The function will return TRUE as value1 equals value2.
Example 2
=GTE((A3*0.1), 830)
If the value in cell A3 multiplied by 0.1 is greater than or equal to 830, the function will return TRUE, else will return FALSE.
Take a look at this tutorial, which gives the steps to use the Google Sheets LT, GT, LTE, and GTE functions, with examples.