Less Than or Equal To in Google Sheets

In this tutorial article, I am going to talk about the “less than or equal to” operator available in Google Sheets and its functions.

Let me get started!

Greetings from TeqTog, where you can find anything you would need to know on Google spreadsheets!

First of all, you need to know what “Less Than or Equal To” feature in Google Sheets, is.

The “less than or equal to” is basically an operator in Google Sheets; which sets the direction of your calculation. If you want to know more about operators and how they function in Google Sheets, then make sure to check out TeqTog’s previous articles on them.

In any case, I will explain operators to you in short.

What are Operators?

Operators are features which determine the type of calculation you wish to execute on your values. There are essentially four kinds 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 operators and how to do math in Google Sheets; you can check out our Math in Google Sheets article.

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

Operator NameOperator TypeSymbolCondition of the Operator
Less Than or Equal ToComparison Operator<=Is less than or equal to the value

All Comparison Operators

Here is the six mathematical comparison operators and symbols in Google Sheets to use.

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

If you need to know about the comparison operators and their use make sure to read “Does Not Equal in Google Sheets”, “Equal to in Google Sheets”, “Less than in Google Sheets” and “Greater than in Google Sheets” articles in our tutorial lists (here is the sitemap of all articles).

Less than or Equal to Functions: How to use

Following my previous examples, I have two sets of values in two columns: Set A and Set B. Within these values, I want to check which values in column A is less than or equal to the values in Column B.

Less than or Equal to Functions: How to use

Just like the “Less Than” and “Greater Than” operators, you can either use the “<=” operator or the “LTE” function interchangeably, to make the same comparison. That’s why I have two columns to show you how you can use both the operator and the “LTE” function.

Formula for the Less Than or Equal To “<=” 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 applying this formula, I can confirm two things: if the value in A2 is less than the value in B2 and, if A2 is equal to the value in B2. My spreadsheets will return “Yes” if my logical conditions are met and “No” if they are not met.

Formula for the Less Than or Equal To “<=” 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.

Results of Formula for the Less Than or Equal To Operator

Formula for the “LTE” Function

On the other hand, the syntax for the “LTE” function will be:

=LTE(value 1, value 2)

and then,

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

The “LTE” function will show me whether the value in A2 is LESS THAN OR EQUAL TO (LTE) the value in B2.

Formula for the “LTE” Function

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

Less Than or Equal To in Google Sheets

So, that wraps up my article on, how you can use the less than or equal to operator in Google Sheets.  

I hope you will find my tutorial helpful. Best of luck!

Related More Articles

Leave a Comment