Does Not Equal in Google Sheets (Symbol <>)

Hello and welcome to TeqTog! In this article, I will discuss how you can use the does not equal to function in Google Sheets. So, let’s get started!

The does not equal symbol in Google Sheets is: “<>”.

Before I can begin my tutorial on how you can use Does Not Equal in Google Sheets, it is important that you learn about this feature first.

Introduction to the Does Not Equal in Google Sheets

The Does Not Equal is a comparison operator in Google Sheets. The purpose of this feature is to confirm whether a value or data in a cell is not equal to a value or data in another cell located in the same, or, different column.

Since Google Sheets is responsible for handling and processing huge volumes of data, this spreadsheet comes with a wide range of useful functions and features to help you work with your numerical information faster and more effectively. One of those useful features would be the Does Not Equal feature.  

Simply put, the Does Not Equal to in Google Sheets is an operator which lets you know about the inequality of values belonging to two different cells.  

  1. The Does Not Equal to feature generates its responses in the forms “TRUE” or “FALSE”.
  2. The “<>” symbol in your keyboard represents the Does Not Equal to feature. This symbol is a combination if two different comparison operators: namely the greater than operator “>” and the less than operator “<”.

The Does Not Equal To Feature: How to use it

The Does Not Equal to tool is essentially used to compare and filter data. This can be achieved with the following steps shown below.

1. Open your Google spreadsheet.

2. You should have a set of data. Let’s assume that I have a list of people and the respective professions they are in. So, in my first column, I have gathered the names of these people and in column B, I have the names of their fields and professions.

Does Not Equal in Google Sheets

As you can see, I plan on seeing my results on the third column (column C) on applying the Does Not Equal operation.

3. In cell number C2 I will give my input for the formula of this operator. The syntax of the formula will be:

=B2<>[insert value which I want to check the inequality of]

This formula implies that I am checking cell number B2, to see if its value does not match with the value “Medicine”.

So, suppose I want to confirm how many people are not working in the field of medicine. Therefore, my input will be

=B2<>“Medicine”

applying the Does Not Equal operation

4. Now, I will press the “Enter” key on my keyboard to get the results.

As shown in my example, after I have pressed “Enter” following the input of my Does Not Equal formula, my spreadsheet has generated the answer “False” for the first row. This is so because; the cell B2 does contain the text value “medicine”. Therefore, when I wanted to check whether the value in the cell does not equal to “medicine”, Google Sheet responded with “FALSE”.

Does Not Equal in Google Sheets - Example

To apply the same Does Not Equal formula to the rest of the row, I can simply select the cell B2 and drag my cursor till the end of the list. Alternatively, Google Sheets will also suggest an “Auto Fill” option for you. If you choose to do so, the answers for the rest will pop up on its own as well.

You can filter out the cells with the “TRUE” results to see all of the people who are not working in medicine.

Comparison Operators: Others

Apart from the Does Not Equal operator, there are five other mathematical operators available in Google Sheets.

Operator NameSymbol
Greater than
Less than
Equal to=
Not Equal to<> 
Greater than, or equal to>=
Less than, or equal to<=

I hope my tutorial on how to use the Does Not Equal operator in Google Sheets will be of help to you.

Best of luck!

Read Our More Google Sheets Tutorials on:

How to Make a Line Graph in Google Sheets

How to Underline and Double Underline in Google Sheets

How to use Google Finance Function in Google Sheets (GOOGLEFINANCE function)

Was this article helpful?
YesNo


Related More Articles

Leave a Comment