Excel “Not Equal” Comparison Operator: Syntax, Examples

-

|

Introduction

Excel “Not Equal” is a Comparison operator that compares two values. “Not Equal” will return TRUE if the values are NOT equal. However, if the values are equal, the operator will return FALSE.

It is important to note how this operator works as it can easily be confused. A TRUE means the compared values ARE NOT EQUAL. However, a FALSE means the values are EQUAL.

This guide covers how to use Excel “Not Equal”. It also covers how “Not Equal” can be combined with other Excel functions to solve business problems.

Excel “Not Equal” Syntax

The syntax of Excel “Not Equal” is:

[value1] <> [value2]

value1: the first value to be compared
<>: Not Equal to sign
value2: the second compared value

Advertisements


Excel “Not Equal” Example (IF, COUNTIF and “NOT Equal”)

The table below shows students scores in a particular subject. The pass mark is 60.

Excel "Not Equal" Example (IF, COUNTIF and "NOT Equal")

In this example, I will show how to combine Excel “Not Equal” with IF and COUNTIF function.

In the first part of the worksheet (column D), I used IF to determine if a student passed or failed. Here is a sample formula:

=IF(C7>=$C$3,"Pass","Fail")

The formula above compares the absolute value of C3 with what each student scores in column C. IF a student scores greater than or equal to (>=) 60 it returns “Pass”. Otherwise it returns “Fail”.

Then, Excel “Not Equal” is used to count the number of students that passed the subject. Below is the formula used:

=COUNTIF(D7:D11,"<>FAIL")

The formula counts cells D7 to D11, if the value is NOT “Fail”. The result is 3 (in cell D13).

Excel “Not Equal” Example (SUMIF and “NOT Equal”)

In this example, excel will sum the numbers in a range if Not Equal to a specified value. The table below specifies list of fruits or vegetables and quantities sold.

To determine the quantity of all products sold except Oranges, use the formula below:

=SUMIF(B3:B7,"<>Oranges",C3:C7)

Excel Not Equal, “<>Oranges” is the part of the formula that tells SUMIF to sum everything in cells C3 to C7 except for Oranges. The result is 250 (cell D9)

Comparison Operators and Meaning

The table below list calculation operators that compares two values. These operators has been combined with Excel “Not Equal” operator in the examples used in this guide.

S/NOperatorWhat it MeansExampleResult
1 <>Not Equal to1<>2TRUE
2 <=Less than or Equal to1<=2TRUE
3>=Greater than or Equal to1>=2FALSE
4<Less than1<2TRUE
5>Greater than1>2FALSE
6=Equal to2=1FALSE

Conclusion

Excel “Not Equal” operator is a very useful operator that returns TRUE if values compared are NOT equal. I hope I have been able to simplify how to use “Not Equal”.

If you have a question or comment use the “Leave a Reply” form at the end of the page. You could also share your experience.

Other Helpful Guides

Additional Resources and References

  • Was this post Helpful?
  • YesNo

LEAVE A REPLY

Please enter your comment!
Please enter your name here

FEATURED POSTS

How to Add Bullet Points in Google Slides

How to Add Bullet Points in Google Slides (Android or iOS Apps or PC)

This Itechguide teaches you how to add bullet points in Google Slides. The guide offers steps to add bullet points in Google...
How to Create a Business Facebook Page without a Personal Account

How to Create a Business Facebook Page without a Personal Account

This Itechguide teaches how to create a business Facebook page without a personal account. There could be a...
How to Wrap Text in Google Sheets

How to Wrap Text in Google Sheets (from a PC or the Apps)

This Itechguide teaches you how to wrap text in Google Sheets. The guide offers steps to wrap text in Google Sheets from...
How to Change Birthday on Facebook

How to Change Birthday on Facebook (from the App or PC)

This Itechguide teaches you how to change birthday on Facebook. The guide contains steps to change birthday on Facebook from the Facebook...
Best Thrillers on Netflix

The 10 Best Thrillers on Netflix

The thrillers on Netflix is quite a large number of movies. Knowing the best thrillers to watch can be a challenge.

ADVERTISEMENTS

TRENDING POSTS

Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...

Find My Samsung: Register and Use Samsung Find my Mobile

Introduction Ever wondered how you could find your Samsung phone if you lost it? Find my Samsung or Samsung...
What is the Difference Between PowerShell and CMD?

Windows Powershell vs CMD: Differences and Similarities

Introduction This short guide compares Windows PowerShell vs CMD (Windows command prompt). I will cover the history and nature...
Spotify No Longer Supports this Version of Microsoft Edge

Spotify No Longer Supports this Version of Microsoft Edge [Fixed]

Introduction When you open Spotify web player on Microsoft Edge, you may receive the error message "Spotify No Longer...
Windows 10 Won't Boot

Windows 10 Won’t Boot With Black Screen? 3 Ways to Fix It

Why Won't Windows 10 Boot Up? If your Windows 10 stops with a black screen, the first question in...

BEST OF ITECHGUIDES

Update Windows 7 to Windows 10

How to Upgrade Windows 7 to Windows 10 (2 Methods)

Introduction This guide demos 2 methods to update Windows 7 to Windows 10 free: Update...

DHCP vs Static IP: How to Set a Static IP or Enable DHCP in...

What is DHCP vs Static IP Address? This tutorial will compare the difference between DHCP vs Static IP addressing....
Gmail Mark All as Read: How to Mark all Emails as Read on Gmail

How to Mark all Emails as Read on Gmail

Introduction If you receive a lot of emails that you do not wish to read, you may want to...
Steps to Fix "Windows has Detected an IP Address Conflict"

How to Fix “Windows has Detected an IP Address Conflict”

Introduction "Windows has Detected an IP Address Conflict" means that two computers on the network have the same IP...
Install and Configure Windows Deployment Services in Server 2019

Install and Configure Windows Deployment Services in Server 2019

Introduction This guide demos how to install and configure Windows Deployment Services in Server 2019 Steps...

ADVERTISEMENTS

RECENT POSTS

How to Logout of Amazon App

How to Logout of Amazon App (from Android, iPhone or Windows 10)

This Itechguide teaches you how to logout of Amazon app. The guide offers steps to logout of Amazon app for Android, for...
How to Turn off YouTube Notifications

How to Turn off YouTube Notifications (PC or YouTube Apps)

This Itechguide teaches you how to turn off YouTube notifications. The guide offers steps to turn off YouTube notifications from a PC...
How to Change YouTube Thumbnail

How to Change YouTube Thumbnail (PC or YouTube Studio App)

This Itechguide teaches you how to change YouTube thumbnail. The guide offers steps to change YouTube thumbnail from a PC or...
How to Add Bullet Points in Google Slides

How to Add Bullet Points in Google Slides (Android or iOS Apps or PC)

This Itechguide teaches you how to add bullet points in Google Slides. The guide offers steps to add bullet points in Google...
How to Change Shipping Address on Amazon

How to Change Shipping Address on Amazon

This Itechguide teaches you how to change shipping address on Amazon. The guide offers steps to change shipping address on Amazon:

MUST READ

How to Delete Playlists on YouTube from Desktop or Mobile Apps

How to Delete Playlists on YouTube from Desktop or Mobile Apps

This guide demos how to delete playlists on YouTube. It provides steps to delete playlists on YouTube from a desktop or YouTube...
car racing games

iTechGuides’ Best 10 Car Racing Games for Consoles

Are you ready for intense car racing? Games in general have advanced in terms of graphic quality and realism. These features are...
How to PM on Facebook

How to PM on Facebook (Send a Private Message on Facebook)

Introduction If you are looking to send a friend a private message (PM) on Facebook, you are in the...
How to Edit a Post on Facebook

How to Edit a Post on Facebook (from a Smartphone and PC)

Introduction This guide demos how to edit a post on Facebook from a smartphone or a PC.
How to Change to Landscape in Google Docs

How to Change to Landscape in Google Docs (from the Apps or a PC)

This Itecguide teaches you how to change to landscape in Google Docs. The guide offers steps to change to landscape in Google...

LATEST DEALS

Exclusive Student Offer_Save 10% on selected Surface devices

By using this website you agree to accept our Privacy Policy and Terms & Conditions