• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Not Equal To In Excel

March 4, 2021 by Andrew Childress
two lists data not equal to in Excel

If you're comparing two lists of data in Excel, you might need the help of a formula. Heres how to check if cells are not equal to in Excel.

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.

two lists data not equal to in Excel

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

Compare cells Excel

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.

True false pulldown

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.

Dice roll number test

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.)

if statement added

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.

Compared cells Excel

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Cells divide in ExcelDivide in Excel
Next Post:Hide Columns in ExcelHide columns in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top