Download the practice workbook and try these yourself. We recommend you learn and apply all these instructions to your dataset. To conclude, I hope this tutorial has provided you with a piece of useful knowledge to use the Not Equal To operator in Excel. For instance, if you compare “ ball” and “ BALL” in, it will return FALSE. ✎ Not Equal To operator is case-insensitive. ✎ Make sure your conditions are correct while using the Not Equal To operator. ✎ Not Equal To operator requires at least two values to check.
First, type the following formula in Cell D5:Īs you can see, we have calculated the average salary of “Male” and “Female” with the help of the AVERAGEIF function and Not Equal To operator.If anyone’s grade is not equal to “ F”, they are passed. Now, our goal is to find the students who failed the exam. Here, we have some students’ names and their grades. Now, take a look at the following dataset:
Then, it will return the result based on this. Now, you can use the Not Equal To operator as a condition in the IF function. Here, we are combining the Not Equal To operator with the IF function in Excel. It will surely enrich your Excel knowledge. We recommend you learn and apply all these. In the following section, we are providing you with five suitable and effective examples that you can implement into your dataset. So, this is the primary usage of the Not Equal To operator in Excel.ĥ Examples of ‘Not Equal to’ Operator with Other Functions On the other hand, if the values are equivalent, it returns FALSE. Here you can see wherever the values are not equal, it returns TRUE. The Values can be anything, it may be text, numerical values or you can use the cell references here.