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

Advertisement

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
Advertisement

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

LEAVE A REPLY

Please enter your comment!
Please enter your name here

FEATURED POSTS

network discovery keeps turning off server 2016

How to Fix Network Discovery If it Keeps Turning Off in Server 2016

Does network discovery keep turning off in your Windows server 2016? It is likely that one of its dependent services is not...
how to install windows 10 1903 update manually

How to Install Windows 10 1903 Update Manually

Windows 10 1903 Update was released in May, 2019. But some users are not yet offered the update via automatic update. The...
spotify web player not working

Spotify Web Player Not Working [Fixed]

Introduction Spotify Web Player may stop working for you with the following error messages: "Spotify Web Player an Error...
DISM.exe /Online /Cleanup-Image /Restorehealth

DISM.exe /Online /Cleanup-Image /Restorehealth Explained

What is DISM.EXE /Online /Cleanup-image /RestoreHealth? "DISM.exe /Online /Cleanup-Image /Restorehealth" is a DISM command that repairs issue with the...
DHCP Relay agent

DHCP Relay Agent: Configuration in Windows Server 2016

What is a DHCP Relay Agent? A DHCP Relay Agent allows DHCP clients in a different network subnet to...

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

Powershell Function

PowerShell Function: Syntax, Parameters, Examples

Introduction There are two types of PowerShell Functions, basic and advanced. A basic PowerShell Function is a list of...
how to share screen on skype

How to Share Screen on Skype on Desktop and Mobile Apps

Introduction What determines how you share screen on Skype depends on a number of factors: Where...

Windows 7 Safe Mode: How to Start Windows 7 in Safe Mode

Introduction If need to perform some advanced troubleshooting on Windows 7, then you may need to start Windows 7...
How to Cancel Spotify Premium

How to Cancel Spotify Premium

Introduction You can cancel Spotify Premium within the 30-day trial. If you cancel Spotify Premium within the trial period,...
how to login to spotify without facebook

How to Login to Spotify Without Facebook

This guide shows you how to login to spotify without Facebook if you are creating a new Spotify account or if you...

RECENT POSTS

disable cortana windows 10 featured

How to Disable Cortana in Windows 10 (2 Methods)

Introduction Some Windows 10 users may not like Cortana. Solution? Disable Cortana. You are probably reading this because you...
bootrec /fixboot access is denied

How to Fix BootRec /FixBoot Access is Denied Error in Windows 10

Introduction BootRec /FixBoot Access is Denied Error in Windows 10? This error is likely caused by corrupt EFI directory.
Reset Windows 10

How to Reset Windows 10 (2 Methods)

Introduction If your Windows 10 is broken, one available way to fix it is to use Windows 10 reset....
system restore windows 10

How to Enable and Use System Restore in Windows 10

Introduction System restore in windows 10 is a very important tool that is probably ignored by most users. But...
windows has stopped this device code 43

How to Fix Windows Has Stopped this Device Code 43 Error

Introduction Sometimes you may receive "Windows has stopped this device code 43" error. This error is likely to come...
Windows could not automatically detect this network's proxy settings

How to Fix “Windows Could not Automatically Detect this Network’s Proxy Settings”

Introduction You suddenly lose the ability to connect to the internet. Then you run network troubleshooter and it returns...
printer offline

5 Ways to Restore Your Printer Online If Status is Offline

Introduction Is your printer offline? Setting it online is very simple but sometimes it is more than just setting...

How to Fix “BootMgr is Missing” Error in Windows 10

Introduction If you receive Fix "BootMgr is missing" Error in Windows 10, the default response is panic! But you...
windows 10 search featured

How to Fix Windows 10 Search If it Stops Working

Introduction Are you having troubles with Windows 10 search? Apparently, it is a fairly common problem with a number...
oooops, something went wrong. reload

How to Fix “Oooops something went wrong. reload” Spotify Error

Introduction If you receive "Oooops something went wrong. reload" Spotify error, do not panic. The fix is simpler than...

MUST READ

WhatsApp web

How to Use WhatsApp Web from a Browser on Your Computer

Introduction WhatsApp web is a WhatsApp service that allows you to use WhatsApp from a browser on your computer....
powershell param

Powershell Param: Syntax, Types, Attributes and Examples

Introduction A Powershell Param block is used to add parameters to advanced functions. Powershell Param adds parameters that can...
FTP and SFTP ports

FTP and FTP Port, SFTP and SFTP Port: Quick Reference

Introduction FTP and SFTP are two protocols for transferring files between a server and a client computer. FTP port...
WSUS

WSUS (Windows Server Update Service): Installation and Configuration

What is WSUS Server? WSUS (Windows Server Update Service) is a Microsoft Server role that allows download and installation...
Excel Count

Excel Count: How to Count in Excel With Examples

Introduction Excel COUNT Function is used for counting items in a worksheet. Excel COUNT also has the conditional function,...

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