How to use Less Than Comparison Operator in Google Sheets (<)

Hello, there! Welcome to TeqTog, your very own learner’s guide to everything about Google spreadsheets! In this article, I am going to talk about the less than comparison operator in Google Sheets, its functions and how you can use it.

Let us get right into it!

First of all, you need to know what kind of feature is Less Than in Google Sheets. Well, the less than is an operator available in Google Sheets; which lets you decide on the type of calculation you want to make.

If you have read our previous articles on operators, then you would know what they are, but, I am going to give you a little brief about them just in case you have not.

What are Operators in Google Sheets?

Operators are determining factors which identify the type of calculation you wish to perform on a set of values. There are primarily 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 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 about in this article falls in the comparison operator category.

Operator NameOperator TypeOperator SymbolCondition of the Operator
Less thanComparison Operator<Is less than the value

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<=

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

How to Use the Less Than 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 Less Than Operator in Google Sheets

You can use the “<” operator or the “LT” function alternatively, to draw the same comparison. That is why; I have two columns to show you how you can use both the operator and the “LT” function.

Formula for the Less Than “<” Operator and How to Use (Example)

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”)

This formula implies that my spreadsheet will check whether the value in cell A2 is less than the value in B2. If so, it will return the result as “Yes” and if that’s not the case, it will give me “No” as the result.

Formula for the Less Than Operator

2. Press “Enter” to get the results and use “auto-fill” to get the same results for the rest of the column.

Results of Example of use of Formula for the Less Than Operator

Formula for the “LT” Function (Example)

If you choose to use the “LT” function, then the syntax for the formula will be:

LT(value 1, value 2)

and then,

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

“LT” has the same function as the “<” operator, therefore, this formula will confirm whether the value in A2 is LESS THAN (LT) the value in B2.

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

Formula for the “LT” Function

2. I will press “Enter” to get my results and use the pop-up option of “auto-fill” to get the same results for the rest of my list.

Results of Example of use of Formula for the “LT” Function

Ad there you go! That’s pretty much all about using the less than operator in Google Sheets.

I hope my article will be of helpful to you. Best of luck!

Check Out Our More Article of Google Sheets Tips:

How to Search IF Cell Contains in Google Sheets

Google Sheets Notes Vs Comments

How to Freeze Rows in Google Sheets

Was this article helpful?
YesNo


Related More Articles

Leave a Comment