We can use the “Not equal to” comparison operator in Excel to check if two values are not equal to each other. In Excel, the symbol for not equal to is <>. When we check two values with the not equal to formula, our results will be Boolean values which are either True or False. In this tutorial, we will explore the ways to use the Not Equal to Boolean operator in Excel.
Figure 1 – Not equal sign in Excel
Using the “Not Equal to” to test numeric values and text values
We will prepare a data table and then test values from our data table using the <> symbol.
Figure 2 – Data for showing the excel not equal formula
- In Cell D4, we will enter the formula below and press OK
- Our result will be displayed as either TRUE or FALSE.
Figure 3 – Not equal to in excel
- If we drag down the formula into other cells in Column C, we will have:
Figure 4 – Does not equal in excel
Using a “Not Equal To” in Excel IF Formula
We can write IF Statements with the not equal to operator to show specific results when particular conditions are met or not.
- Again, we will prepare a data table
Figure 5 – Does not equal in excel
- In Cell C4, we will insert the formula and press the enter key
=IF(A4<>B4,"Product Not Matching", "Product Matching")
Figure 6 – How to do not equal in excel
- We will copy down the formula into other cells.
Figure 7 – Not equal to symbol in excel
Using the Not Equal to in Excel COUNTIF formula
We can use the not equal to operator to count the number of cells that contain values not equal to a particular value. In this section, we will use the COUNTIF function and the not equal to operators to count other items in our list except the specified item.
- We will prepare a data table
Figure 8 – Boolean operators in excel
- To count all items except Cereal. In Cell E4, we will enter the formula below and press the enter key.
Figure 9 – comparison operators in excel
- To Count all other items except Soda, we will click on Cell E5, and enter the formula below.
Figure 10 – Does not equal in excel
- To Count all items except Snacks, we will click on Cell E6, and enter the formula below
Figure 11 – Boolean operator in excel