# 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″)

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