Excel “Not Equal” is a Comparison operator that compares two values. “Not Equal” will return TRUE if the values are NOT equal. However, if the values are equal, the operator will return FALSE.
This guide covers how to use Excel “Not Equal”. It also covers how “Not Equal” can be combined with other Excel functions to solve business problems.
Excel “Not Equal” Syntax
The syntax of Excel “Not Equal” is:
[value1] <> [value2]
value1: the first value to be compared
<>: Not Equal to sign
value2: the second compared value
Example 1: IF, COUNTIF and “NOT Equal”
The table below shows students scores in a particular subject. The pass mark is 60.
In this example, I will show how to combine Excel “Not Equal” with IF and COUNTIF function.
In the first part of the worksheet (column D), I used IF to determine if a student passed or failed. Here is a sample formula:
=IF(C7>=$C$3,"Pass","Fail")
The formula above compares the absolute value of C3 with what each student scores in column C. IF a student scores greater than or equal to (>=) 60 it returns “Pass”. Otherwise it returns “Fail”.
Then, Excel “Not Equal” is used to count the number of students that passed the subject. Below is the formula used:
=COUNTIF(D7:D11,"<>FAIL")
The formula counts cells D7 to D11, if the value is NOT “Fail”. The result is 3 (in cell D13).
Example 2: SUMIF and “NOT Equal”
In this example, excel will sum the numbers in a range if Not Equal to a specified value. The table below specifies list of fruits or vegetables and quantities sold.
To determine the quantity of all products sold except Oranges, use the formula below:
=SUMIF(B3:B7,"<>Oranges",C3:C7)
Excel Not Equal, “<>Oranges” is the part of the formula that tells SUMIF to sum everything in cells C3 to C7 except for Oranges. The result is 250 (cell D9)
Comparison Operators and Meaning
The table below list calculation operators that compares two values. These operators has been combined with Excel “Not Equal” operator in the examples used in this guide.
S/N | Operator | What it Means | Example | Result |
1 | <> | Not Equal to | 1<>2 | TRUE |
2 | <= | Less than or Equal to | 1<=2 | TRUE |
3 | >= | Greater than or Equal to | 1>=2 | FALSE |
4 | < | Less than | 1<2 | TRUE |
5 | > | Greater than | 1>2 | FALSE |
6 | = | Equal to | 2=1 | FALSE |
Conclusion
Excel “Not Equal” operator is a very useful operator that returns TRUE if values compared are NOT equal. I hope I have been able to simplify how to use “Not Equal”.
I also hope you found this Itechguide helpful. Use the “Was this page helpful?” quick feedback below to share your thoughts about this guide.
Alternatively, you could use the comment form – “Leave a Reply” – at the bottom of this page.