EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Certification Courses
  • 120+ Courses All in One Bundle
  • Login

Not Equal To Excel

By Karthikeyan SubburamanKarthikeyan Subburaman

Home » Excel » Blog » Excel Tips » Not Equal To Excel

Not Equal To in Excel

Excel Not Equal To (Table of Contents)

  • Not Equal To in Excel
  • How to Put ‘ Not Equal To ‘ in Excel?

Not Equal To in Excel

Not Equal To generally is represented by striking equal sign when the values are not equal to each other. But in Excel, it is represented by greater than and less than operator sign “<>” between the values which we want to compare. If the values are equal, then it used the operator will return as TRUE, else we will get FALSE. We can use the Not Equal operator along with other conditional functions as IF, SUMIF, COUNTIF function to get some other kind of meaning of results.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

How to Put ‘ Not Equal To ‘ in Excel?

Not Equal To in Excel is very simple and easy to use. Let’s understand the working of Not Equal To Operator in Excel by some examples.

You can download this Not Equal To Excel Template here – Not Equal To Excel Template

Example #1 – Using ‘ Not Equal To Excel ‘ Operator

In this example, we are going to see how to use the Not Equal To logical operation <> in excel.

Consider the below example, which has values in both the columns now; we are going to check the Brand MRP of Amazon and Flipkart.

Not Equal To Example 1-1

Now we are going to check that Amazon MRP is not equal to Flipkart MRP by following the below steps.

  • Create a new column.

Not Equal To Example 1-2

  • Apply the formula in excel as shown below.

Not Equal To Example 1-3

  • So as we can see in the above screenshot, we applied the formula as =B3<>C3 here, we can see that in the  B3 column Amazon MRP is 1400, and Flipkart MRP is 1400, so the MRP matches exactly.
  • Excel will check if B3 values are not equal to C3, then it returns TRUE or else it will return FALSE.
  • Here in the above screenshot, we can see that Amazon MRP is equal to Flipkart MRP, so we will get the output as FALSE, which is shown in the below screenshot.

Not Equal To Example 1-4

  • Drag down the formula for the next cell. So the output will be as below:

Not Equal To Example 1-5

  • We can see that the formula =B4<>C4; in this case, Amazon MRP is not equal to Flipkart MRP. So excel will return the output as TRUE, as shown below.

Not Equal To Example 1-6

Example #2 – Using String

In this excel example, we are going to see how not equal to excel operator works in strings. Consider the below example, which shows two different titles named for Amazon and Flipkart.

Popular Course in this category
Sale
Excel Training (21 Courses, 9+ Projects)21 Online Courses | 9 Hands-on Projects | 110+ Hours | Verifiable Certificate of Completion | Lifetime Access
4.9 (10,706 ratings)
Course Price

View Course

Related Courses
Excel Data Analysis Training (15 Courses, 8+ Projects)Excel for Finance Training (18 Courses, 7+ Projects)

Not Equal To Example 2-1

Here we will check that Amazon’s title name matches the Flipkart title name by following the below steps.

  • First, create a new column called Output.

Not Equal To Example 2-2

  • Apply the formula as =A2<>B2.

Not Equal To Example 2-3

  • So the above formula will check for A2 title name is not equal to B2 title name if it is not equal, it will return FALSE or else it will return TRUE as we can see that both the title names are the same and it will return the output as FALSE which is shown in the below screenshot.

Not Equal To Example 2-4

  • Drag down the same formula for the next cell. So the output will be as below:

Not Equal To Example 2-5

  • As =A3<>B3, where we can see the A3 title is not equal to the B3 title, so we will get the output as TRUE which is shown as the output in the below screenshot.

Not Equal To Example 2-6

Example #3 – Using IF Statement

In this excel example, we are going to see how to use the if statement in the Not Equal To operator.

Consider the below example, where we have title names of both Flipkart and Paytm, as shown below.

Not Equal To Example 3-1

Now we are going to apply the Not Equal To Excel operator inside the if statement to check both the title names are equal or not equal by following the below steps.

  • Create a new column as Output.

Not Equal To Example 3-2

  • Now apply the if condition statement as follows =IF(A2<>B2, “Title Not Matching”, “Title Matching”)

Using IF formula Example 3-3

  • Here in the if condition, we used not equal to Operator to check whether the title is equal to or not equal.
  • Moreover, we have mentioned in the if condition in double-quotes as “Title Not Matching”, i.e., if it is not equal to it, it will return as “Title Not Matching”, or else it will return “Title Matching”, as shown in the below screenshot.
  • As we can see that both the title names are different, and it will return the output as Title Not Matching which is shown in the below screenshot.

Using IF formula Example 3-4

  • Drag down the same formula for the next cell.

Not Equal To Example 3-5

  • In this example, we can see that the A3 title is equal to the B3 title; hence we will get the output as “Title Matching “, which is shown as the output in the below screenshot.

Result of Example 3-6

Example #4 – Using the COUNTIF Function

In this excel example, we are going to see how the COUNTIF Function works in the Not Equal To operator.

Consider the below example, which shows student’s subject marks along with the grade.

Not Equal To Example 4-1

Here we are going to count how many students have taken the marks in it equal to 94 by following the below steps.

  • Create a new row named as Marks Not Equal To 50.

Not Equal To Example 4-2

  • Now apply the COUNTIF formula as =COUNTIF(C2:C7,”<>50″)

Using COUNTIF formula Example 4-3

  • As we can see in the above screenshot, we have applied the COUNTIF function to find out Student marks not equal to 50. We have selected the cells C2:C7, and in the double quotes, we have used <> not equal to Operator and mentioned the number 50.
  • The above formula counts the student’s marks which is not equal to 50, and return the output as 5, as shown in the below result.
  • In the below screenshot, we can see that marks not equal to 50 are 5, i.e. Five students scored marks more than 50.

Using COUNTIF formula Example 4-4

  • Now we will use a string to check the student’s grade stating how many students are not equal to the grade “Very Good”, which is shown in the below screenshot.

Not Equal To Example 4-5

  • For this, we can apply the formula as =COUNTIF(D2:D7,”<>”& A9).

Using COUNTIF formula Example 4-6

  • So this COUNTIF function will find the student’s grade from the range we have specified D2:D7 using the Not Equal To Excel OPERATOR. The grade variable “VERY GOOD” has been concatenated by the operator “&” by specifying A9. Which will give us the result of 3, i.e. 3 students grade are not equal to “Very Good” which is shown in the below output.

Using COUNTIF formula Example 4-7

Things to Remember About Not Equal To in Excel

  • In Microsoft excel, logical operators mostly used in conditional formatting, which will give us the perfect result.
  • Not Equal To operator always requires at least two values to check either it is “TRUE” or “FALSE”.
  • Make sure that you are giving the correct condition statement while using the Not Equal To the operator, or else we will get an invalid result.

Recommended Articles

This has been a guide to Not Equal To in Excel. Here we discuss how to put Not Equal To in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Formatting Text in Excel
  2. Add Rows in Excel Shortcut
  3. COUNTIF Excel Function
  4. SUMIF Function in Excel

All in One Excel VBA Bundle (120+ Courses, 30+ Projects)

120+ Online Courses

30+ Projects

500+ Hours

Verifiable Certificates

Lifetime Access

Learn More

0 Shares
Share
Tweet
Share
Primary Sidebar
Excel Functions
  • Excel Tips
    • Recover Document in Excel
    • Excel Shortcut to Select Row
    • Excel Header Row
    • Excel Insert Button
    • Excel Translate
    • Budget in Excel
    • KPI Dashboard in Excel
    • Blank Invoice Excel Template
    • Write Formula in Excel
    • Auditing Tools in Excel
    • Autofit Row Height in Excel
    • Formatting Text in Excel
    • Add Rows in Excel Shortcut
    • Divide Cell in Excel
    • Compare Two Columns in Excel for Matches
    • Excel Troubleshooting
    • Unprotect Excel Workbook
    • Subtract Date in Excel
    • Carriage Return in Excel
    • Negative Numbers in Excel
    • Worksheets in Excel
    • Excel Match Multiple Criteria
    • Exponential Moving Average Formula
    • Sentence Case in Excel
    • Excel Reverse Order
    • Excel Timesheet Template
    • Weighted Average in Excel
    • CTRL Shift-Enter in Excel
    • Excel Expense Tracker
    • INDEX MATCH Function in Excel
    • Percent Change in Excel
    • Drag and Drop in Excel
    • Shade Alternate Rows in Excel
    • Excel Database Template
    • Inverse Matrix in Excel
    • New Line in Excel Cell
    • Format Cells in Excel
    • Excel Text with Formula
    • Project Management Template in Excel
    • Vlookup vs Index Match
    • Embedded in Excel
    • Count Colored Cells in Excel
    • Excel Hacks
    • Column Header in Excel
    • Database Function in Excel
    • Excel Spell Check
    • Linear Interpolation in Excel
    • Convert Excel to CSV
    • Excel Not Responding
    • Delta Symbol in Excel
    • Excel Mortgage Calculator
    • Excel Show Formula
    • Break Links in Excel
    • VLOOKUP Examples in Excel
    • Alternate Row Color Excel
    • Checklist in Excel
    • Microsoft Office Tips
    • Excel vs Access
    • Excel Change Case
    • Count Characters in Excel
    • Formula Bar in Excel
    • Invoice Template in Excel
    • Find and Replace in Excel
    • PowerPivot in Excel
    • Wildcard in Excel
    • Line Break in Excel
    • NULL in Excel
    • Text Formula in Excel
    • Family Tree in Excel
    • Insert Calendar in Excel
    • Page Setup in Excel
    • Search For Text in Excel
    • Switching Columns in Excel
    • 3D Cell Reference in Excel
    • Roadmap Template in Excel
    • Cell References in Excel
    • Excel Automation
    • Matching Columns in Excel
    • Evaluate Formula in Excel
    • How to Find Mean in Excel
    • How to Add Cells in Excel
    • Project Timeline in Excel
    • TODAY Formula in Excel
    • Poisson Distribution in Excel
    • YEAR Formula in Excel
    • REPLACE Formula in Excel
    • Create Spreadsheet in Excel
    • SEARCH Formula in Excel
    • HYPERLINK Formula in Excel
    • Pivot Table with Multiple Sheets
    • COLUMNS Formula in Excel
    • DAY Formula in Excel
    • RIGHT Formula in Excel
    • INDIRECT Formula in Excel
    • Excel IRR Formula
    • Pivot Table Sort
    • OR Formula in Excel
    • Pivot Table Formula in Excel
    • How to Edit Drop Down List in Excel?
    • WEEKDAY Formula in Excel
    • Chart Wizard in Excel
    • Time Difference in Excel
    • Lookup Table in Excel
    • SUBTOTAL Formula in Excel
    • LOOKUP Formula in Excel
    • Themes in Excel
    • Group Worksheets in Excel
    • Excel ISNUMBER Formula
    • 3D Maps in Excel
    • VLOOKUP Tutorial in Excel
    • Moving Columns in Excel
    • Grouping Columns in Excel
    • Excel Formula of Percentage
    • Excel Leading Zeros
    • Timesheet in Excel
    • Nested IF Formula in Excel
    • SUMIF Formula in Excel
    • Concatenation in Excel
    • Excel Insert Page Break
    • LEN Formula in Excel
    • Insert Comment in Excel
    • Excel Print
    • Fractions in Excel
    • Excel Add a Column
    • Borders in Excel
    • Excel Sum by Color
    • Excel vs Google Sheets
    • Calculate Percentage Increase in Excel
    • Excel Format Phone Numbers
    • Excel Search Box
    • Excel vs CSV
    • Excel vs Numbers
    • Excel Concatenate Date
    • Excel Bullet Points
    • Calculate Compound Interest in Excel
    • Find External Links in Excel
    • Excel Comma Style
    • Excel Remove Leading Spaces
    • Combine First and Last Name in Excel
    • How to Calculate Ratio in Excel
    • SUMPRODUCT Function with Multiple Criteria
    • Create Excel Template
    • Excel Greater than or Equal
    • Excel Keyboard Shortcuts
    • Excel Row vs Excel Column
    • Excel Operators
    • Excel Text Compare
    • Excel Uppercase Function
    • Excel Auto Numbering
    • Watermark in Excel
    • Excel Delete Row Shortcut
    • Excel Word Count
    • Row Count in Excel
    • Excel Grade Formula
    • Excel Percentage Difference
    • Excel Rows and Columns
    • Excel Group
    • Excel Move Columns
    • Excel Row Height
    • Excel Sparklines
    • Excel Drawing a line
    • Multiple IFS in Excel
    • Excel Strikethrough
    • Numbering in Excel
    • Share Excel Workbook
    • Excel Shortcut For Merge Cells
    • Excel OneDrive
    • Excel Track changes
    • Excel Hide Formula
    • Excel Filter Shortcuts
    • Excel 3D Reference
    • Protect Excel Workbook
    • Excel Moving Averages
    • Excel Row Limit
    • Excel Absolute Value
    • Excel Print Area
    • Excel Format Painter
    • Excel Separate text
    • Excel Autofit
    • Excel Columns to Rows
    • Excel Paste Shortcut Option
    • Excel Rows to Columns
    • Excel Insert Row Shortcut
    • Excel Extensions
    • Excel Unmerge Cells
    • Divide in Excel Formula
    • Excel Compare Two Columns
    • Not Equal To Excel
    • Excel Remove Duplicates
    • Excel Remove Spaces
    • Excel Calculate Age
    • Copy Excel Sheet
    • Excel Conditional Formatting Based on Another Cell Value
    • Excel Cell Reference
    • Excel Split Cell
    • Excel Circular Reference
    • Highlight Every Other Row in Excel
    • Errors in Excel
    • Excel Delete Pivot Table
    • Excel Pivot Table
    • Subtraction in Excel
    • Count Unique Values in Excel
    • Excel Highlight Duplicates
    • Excel Data Formatting
    • Random Numbers in Excel
    • Basic Excel Formulas
    • Page Numbers in Excel
    • Excel CAGR Formula
    • Excel Combine cells
    • IFERROR with VLOOKUP in Excel
    • Column Sort in Excel
    • Print Comments in Excel
    • Cheat Sheet of Excel Formulas
    • Remove Hyperlinks in Excel
    • Excel Drop Down List
    • Remove (Delete) Blank Rows in Excel
    • Relative Reference in Excel
    • Subscript in Excel
    • Superscript in Excel
    • Excel Insert Multiple Rows
    • Excel Absolute Reference
    • Unhide Columns in Excel
  • Excel Functions (12+)
  • Excel Tools (114+)
  • Financial Functions in Excel (17+)
  • Logical Functions in Excel (14+)
  • Lookup Reference Functions in Excel (34+)
  • Maths Function in Excel (47+)
  • TEXT and String Functions in Excel (26+)
  • Date and Time Function in Excel (23+)
  • Statistical Functions in Excel (58+)
  • Information Functions in Excel (4+)
  • Excel Charts (56+)
  • Workplace Productivity (4+)
  • Microsoft Office Tools (15+)
  • Excel Formula and Functions (21+)
  • MS Excel Shortcuts (4+)
Excel Functions Courses
  • EXCEL COURSE
  • Online Excel Data Analysis Course
  • Excel for Finance Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

EDUCBA

Download Not Equal To Excel Template

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Special Offer - EXCEL COURSE Learn More