How to Use Comparison Operators in Google Sheets

When you need to compare values ​​in a spreadsheet, Google Sheets provides you with the standard operators to do so. You can use functions if you prefer, but if regular symbols are your thing, here’s how to use them.

You may want to know if one value is greater than, less than, or equal to another. This is especially useful if you change your data often and need to keep track of these types of comparisons. Let’s see how to use comparison operators in Google Sheets for constants, cell references, and mixed formulas.

HOW TO CREATE A TABLE IN GOOGLE SHEETS USING A TABLE GRAPH

Comparison Operators in Google Sheets

Think back to your elementary or middle school math lessons and these comparison symbols should come to mind. These same symbols are available for comparing values ​​in Google Sheets.

Égal à : =, équivalent de la fonction EQ.
Non égal à : <>, équivalent de la fonction NE
Supérieur à : >, équivalent à la fonction GT
Supérieur ou égal à : >=, équivalent à la fonction GTE
Inférieur à : <, équivalent à la fonction LT
Inférieur ou égal à : <=, équivalent à la fonction GTE

When you compare values ​​using these operators, the result is either True or False. And like any other formula in Google Sheets, you'll start with an equals sign.

Here are several examples.

To find out if the value of cell A1 is equal to the value of cell B1, you can use this formula:

=A1=B1

To see if these same values ​​are not equal to each other, you will use this formula:

=A1<>B1

To see if the value of cell A1 is greater than 150, you can use this formula:

=A1>150

For a final example, to see if 200 is less than or equal to the value in cell B1, use this formula:

=200<=B1

Comparison operator formulas in Google Sheets

As you can see, the formulas are basic and easy to put together. The structure is as follows: equals sign, value one, comparison operator, value two (without the commas).

Comparison operators with functions

In Google Sheets, comparison operators aren't just for comparing two values. They are also very useful when working with functions and other types of formulas.

For example, you can use COUNTIF in Google Sheets to count the number of cells that meet criteria. This is a perfect example of including a comparison operator.

With this formula, we can count the number of cells with values ​​greater than 10 in the cell range A1 to A5:

=COUNTIF(A1:A5, »>10″)

COUNTIF function in Google Sheets

Using another criteria-based function, SUMIF, we can add the values ​​from that same range of cells if they are less than 10 with this formula:

=SUMIF(A1:A5, “<10″)

SUMIF function in Google Sheets

Another function where you will see comparison operators used is the logical IF function. With this formula, we will display the number 1 if the value of cell A1 is equal to No and the number 2 if it is not.

=IF(A1=”No”, “1”, “2”)

IF function in Google Sheets

Comparison operators in Google Sheets give you a quick and easy way to compare values. If you prefer to use the comparison functions, see our handy guide on this subject.

And to work with other symbols in Google Sheets, see how to use the ampersand (&) to add text or concatenate data.

Leave a Comment