Excel not equal to operator
You have performed several basic and advanced operations on Excel data, such as add, subtract to manipulate and analyze the Excel data. Comparison is one more operation that can be performed on Excel data. You can compare two or more values stored in an Excel sheet with each other.
Comparing data is an important and useful operation of Excel, for which Excel provides six logical operators. Not Equal to operator is one of them. It is represented by the <> symbol. In this chapter, we will brief Not Equal to operator (<>) to see how and where we can use it.
We will also provide a brief summary of these six logical operators at the end of this chapter.
Not Equal to operator
Not Equal (<>) is a logical operator. Excel users can use this operator to compare two or more values and determine whether they are the same or different.
If the compared values are not same, it returns TRUE. If the compared values are same, it will return FALSE. The resultant value will be one at a time: either TRUE or FALSE depending on the comparison result.
Use this operator between two conditions (value) by placing an equal sign in the beginning to start the Excel formula. E.g., ="Hello"<>"World"
Note: To write a formula in Excel, you must put = (equal sign) to start the formula.
This operator becomes more interesting when combined with other functions like IF and OR to achieve certain results.
Not Equal formula
Not Equal operator is used between two conditions (values) or cell reference containing data. You can use it as -
We will try to explain this operator with the help of several examples by comparing different values. Thus, it will help you to learn it better.
This operator returns TRUE if the compared values are not the same. On finding the values same, it will return FALSE.
Note: It returns just opposition result to Equal (=) operator.
When this operator is used?
You can use these values when you want to make sure two specific values are not equal to each other.
Additionally, you can also use it inside other functions to make the result more specific. Not Equal to operator is just opposite to Equal to operator.
We will show you different examples to describe the usage and working of the Not Equal To (<>) operator. We will take different examples for number, text, and string data comparison.
Look at our first example below:
Example 1: Compare numbers
We will take an example to compare numeric values to discuss the Not Equal To operator in an Excel worksheet.
When numbers are not same - returns TRUE
Example 2: Compare Strings
Now, we have another example to compare the string type of data stored in an Excel sheet. We will take a string comparison example to compare the text data to explore the working of the Not Equal To operator in an Excel worksheet.
When strings are not same - returns TRUE
Note: You can also provide the string data directly in this formula inside double quotes like (="Hello"<>"Hiii"). It will work the same.
Note: Not Equal to (<>) operator is not case-sensitive when used with text data. So, if two same text string in different CASES is compared using not equal to operator, it will return FALSE.
For example, Hello and HELLO both strings are same in spellings, but CASE is different. Excel Not Equal to (<>) operator ignore the case and treat them same, and return FALSE as its result.
More on String data
Let's see some more operations on string data.
You can also better learn by yourself by inputting different values in the comparison formula. You do not need to provide numeric values in double quotes to compare them as a string. You can put them directly, e.g., 23<>15.
USE <> operation inside a function
Now, you will see that we will use <> inside another function rather using them directly to compare Excel data. For example, inside IF function.
We have some numeric data (marks of five subjects) stored in a column. We will use AVERAGEIF() function and <> operator inside it to compare the average of the values by excluding a specific number.
As we told you, Excel provides six logical operators to compare the data stored in an Excel sheet. These logical operators are equal, not equal, greater than, less than, greater than equal to, less than equal to.
All the operators return TRUE if the condition satisfies for the given values. Otherwise, they return FALSE.
You can learn in more detail about these operators in our Excel logical operator chapter. Learn from here, it will contain two or more examples for each operator.