In excel we are aware of operators like arithmetic and logical operators. Logical operators are mostly used in any organization to compare the two values either it is true or false.

This logical operator is also called Boolean operator (true or false) because it allows us to find out whether the values are not equal to one another, if the values are equal it will return false or else it will return true.

In Excel, <> means not equal to. The <> operator in Excel checks if two values are not equal to each other.

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

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