Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • Number and Text Filters Examples in Excel
  • How to create Gauge Chart in Excel
  • How To Load Analysis ToolPak in Excel
  • How To Sort One Column or Multiple Columns in Excel
  • How to create dynamic reference table name in Excel

References

  • How to get address of first cell in range in Excel
  • How to get address of named range in Excel
  • Two-way lookup with VLOOKUP in Excel
  • How to use Excel MMULT Function
  • How to use Excel ROW Function

Data Validations

  • Excel Data validation allow uppercase only
  • How To Create Drop-down List in Excel
  • Excel Data validation specific characters only
  • Excel Data validation unique values only
  • Excel Data validation exists in list

Not Equal To ‘<>‘ operator in Excel

by

In Excel, <> means not equal to. The <> operator in Excel checks if two values are not equal to each other. Let’s take a look at a few examples.

1. The formula in cell C1 below returns TRUE because the text value in cell A1 is not equal to the text value in cell B1.

2. The formula in cell C1 below returns FALSE because the value in cell A1 is equal to the value in cell B1.

3. The IF function below calculates the progress between a start and end value if the end value is not equal to an empty string (“”), else it displays an empty string (see row 5).

Note: visit our page about the IF function for more information about this Excel function.

4. The COUNTIF function below counts the number of cells in the range A1:A5 that are not equal to “red”.

Note: visit our page about the COUNTIF function for more information about this Excel function.

5. The COUNTIF function below produces the exact same result. The & operator concatenates the ‘not equal to’ operator and the text value in cell C1.

6. The COUNTIFS function below counts the number of cells in the range A1:A5 that are not equal to “red” and not equal to “blue”.

Explanation: the COUNTIFS function in Excel counts cells based on two or more criteria. This COUNTIFS function has 2 range/criteria pairs.

7. The AVERAGEIF function below calculates the average of the values in the range A1:A5 that are not equal to 0.

Note: in other words, the AVERAGEIF function above calculates the average excluding zeros.

Post navigation

Previous Post:

VLOOKUP without #N/A error in Excel

Next Post:

How to Create Gantt Chart in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • How to return blank in place of #DIV/0! error in Excel
  • Excel If, Nested If, And/Or Criteria Examples
  • OR function Examples in Excel
  • How to use Excel FALSE Function
  • IF, AND, OR and NOT Functions Examples in Excel

Date Time

  • How to calculate Quarter of Date in Excel
  • DAYS360 function: Description, Usage, Syntax, Examples and Explanation
  • ISOWEEKNUM function: Description, Usage, Syntax, Examples and Explanation
  • Convert decimal hours to Excel time
  • Get project midpoint in Excel

Grouping

  • Categorize text with keywords in Excel
  • Group numbers with VLOOKUP in Excel
  • If cell contains one of many things in Excel
  • Running count group by n size in Excel
  • Group times into 3 hour buckets in Excel

General

  • Common Errors in Excel
  • How to Insert Cells, Row and Rows in Excel
  • How to calculate percent of students absent in Excel
  • Count cells that contain errors in Excel
  • Excel Ribbon Quick Overview For Beginners
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning