Q:

# What does "not equal" do in Excel?

A:

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

## Keep Learning

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.

Sources:

## Related Questions

• A: Designing a work schedule in Microsoft Excel involves creating a table and inputting the appropriate values where necessary. It is also possible to use Exc... Full Answer >
Filed Under:
• A: While Microsoft Excel does not have a built-in function to find percentage increase between values, a user simply needs to enter the formula "=(B-A)/ABS(A)... Full Answer >
Filed Under:
• A: You can create a formula in Microsoft Excel by using constants and calculation operators, cell references and names, or functions. Simple formulas to add, ... Full Answer >
Filed Under:
• A: You can use Microsoft Excel by entering your information, and then formatting it to create spreadsheets for organizational or analytical purposes. The prog... Full Answer >
Filed Under:
PEOPLE SEARCH FOR