If you’re comparing two lists of data in Excel, you might need the help of a formula to speed up the process. Let’s learn how to check if cells are **not equal to in Excel.**

## Check Not Equal To In Excel

Let’s start with a simple example. Let’s start with two lists of data in two columns.

The simplest way to compare two cells is to write a quick formula. Type **=, **then click on your first cell. Then, add another equals sign and click on another cell. You’re telling Excel to test for equality.

The formula you see below is:

=F2=G2

If two cells *do *match, you’ll get TRUE. Now, pull the formula down to see the rest of the results. Notice in the example below that **FALSE **shows not equal to in Excel results.

If two cells are not equal to one another in Excel, you’ll get a result of **FALSE. **This can help you compare cells and find ones that are not equal to in Excel. This works for comparing both text and numeric values.

## How to Use An If Statement For Not Equal To In Excel

Want to show more than “TRUE” and “FALSE” in Excel? It’s time to learn a bit about IF statements, and use not equal to in Excel formulas.

Let’s look at this example for fun. Let’s say that we’re playing a game of rolling dice and want to see which rolls win.

I’ve set the magic number – a dice roll of 5 – in cell I1. I’ve also recorded seven dice rolls, and now I’m ready to write a formula to check to see which won.

Let’s write an **IF Statement **to check for not equal to in Excel. If statements are formulas that follow this format:

=IF(logical_test, [value if true], [value_if_false])

Basically, you’re asking Excel to test if something is true, and then to show values based on if it’s true.

My example formula is:

=IF(E2<>$I$1,"Lose","Win")

Notice that we’re using “**<>**” to test if two cells are *not *equal. This formula tells Excel to compare E2 to I1, then show LOSE if the cells aren’t equal.

*(Note: the dollar signs in “$I$1” freeze the cell reference so that this works well as we autofill the formula.)*

Now, let’s just pull down the formula. Notice that only the winning cells show “Win.” Combining tests for equality with an if statement is all you need.