What does "not equal" do in Excel?


Quick Answer

The comparison operator “not equal” in Microsoft Excel is used to compare whether one of two numerical values is less than or greater than the other. It is represented using the “less than” and “greater than” mathematical symbols as “<>”.

Continue Reading

Full Answer

When two non-null values are compared using this operator, the result is one of two logical values: true or false. It returns true if the first value is not equal to the second value, and it returns false if the two values are equal. If either value is null, then the result is also null. This is because null represents an unknown value, and the result of any comparison with a null value is also unknown.

For example, (A1<>B1) returns true if the non-null value in cell A1 is not equal to that in cell B1.

Learn more about Software

Related Questions