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**`=C4<>B4`

- 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.`=COUNTIF(A4:A20,"<>Cereal")`

*Figure 9 – comparison operators in excel*

- To Count all other items except Soda, we will click on
**Cell E5,**and enter the formula below.`=COUNTIF(A4:A20,"<>Soda")`

*Figure 10 – Does not equal in excel*

- To Count all items except Snacks, we will click on
**Cell E6,**and enter the formula below`=COUNTIF(A4:A20,"<>Snacks")`

*Figure 11 – Boolean operator in excel*