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

Data Analysis

  • Example of COUNTIFS with variable table column in Excel
  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Move chart to a separate worksheet in Excel
  • Filter Data Based on Date in Excel
  • How to do a t-Test in Excel?

References

  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • Count rows with at least n matching values
  • CHOOSE function: Description, Usage, Syntax, Examples and Explanation
  • Vlookup Examples in Excel
  • Count rows that contain specific values in Excel

Data Validations

  • Excel Data validation number multiple 100
  • Excel Data validation require unique number
  • Excel Data validation allow weekday only
  • Data validation must not exist in list
  • How To Create Drop-down List in Excel

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.

Worked Example:   How to display conditional message with REPT function in Excel

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

Worked Example:   Count items in list in Excel

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

Worked Example:   Count Errors in Excel

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:

Shade Alternate Rows in Excel

Next Post:

How to Create Area 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

  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • IF with wildcards in Excel
  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • Not Equal To ‘<>‘ operator in Excel

Date Time

  • Get day name from date in Excel
  • How to calculate quarter from date in Excel
  • Assign points based on late time in Excel
  • TIME function: Description, Usage, Syntax, Examples and Explanation
  • Calculate time difference in hours as decimal value in Excel

Grouping

  • If cell contains one of many things in Excel
  • Group numbers with VLOOKUP in Excel
  • Group times into 3 hour buckets in Excel
  • Map inputs to arbitrary values in Excel
  • How to randomly assign data to groups in Excel

General

  • Basic numeric sort formula in Excel
  • Subtotal by color in Excel
  • How to increase by percentage in Excel
  • Count cells less than in Excel
  • How to calculate percent of goal in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning