Best Answer

You can use the Not function or the <> operator, which is the < and the > beside each other. To see if the values in A1 and A2 are not equal to each other, you can type:

=A1<>A2

or

=Not(A1=A2)

In each case they will either give you TRUE if they are not equal or FALSE if they are equal, in the cell that you enter the formula into.

More answers

Equal to ( = )

Less than ( < )

Less than or equal to ( <= )

Greater than ( > )

Greater than or equal to ( >= )

Not equal to ( <> )

Equal to ( = )

Less than ( < )

Less than or equal to ( <= )

Greater than ( > )

Greater than or equal to ( >= )

Not equal to ( <> )

Equal to ( = )

Less than ( < )

Less than or equal to ( <= )

Greater than ( > )

Greater than or equal to ( >= )

Not equal to ( <> )

Equal to ( = )

Less than ( < )

Less than or equal to ( <= )

Greater than ( > )

Greater than or equal to ( >= )

Not equal to ( <> )

Equal to ( = )

Less than ( < )

Less than or equal to ( <= )

Greater than ( > )

Greater than or equal to ( >= )

Not equal to ( <> )

Equal to ( = )

Less than ( < )

Less than or equal to ( <= )

Greater than ( > )

Greater than or equal to ( >= )

Not equal to ( <> )

Equal to ( = )

Less than ( < )

Less than or equal to ( <= )

Greater than ( > )

Greater than or equal to ( >= )

Not equal to ( <> )

Equal to ( = )

Less than ( < )

Less than or equal to ( <= )

Greater than ( > )

Greater than or equal to ( >= )

Not equal to ( <> )

Equal to ( = )

Less than ( < )

Less than or equal to ( <= )

Greater than ( > )

Greater than or equal to ( >= )

Not equal to ( <> )

Equal to ( = )

Less than ( < )

Less than or equal to ( <= )

Greater than ( > )

Greater than or equal to ( >= )

Not equal to ( <> )

Equal to ( = )

Less than ( < )

Less than or equal to ( <= )

Greater than ( > )

Greater than or equal to ( >= )

Not equal to ( <> )

You can use the equal sign, the greater than sign and the less than sign. Typically they would be used in an IF function, like this:

=IF(A2>B2, "A2 is greater than B2", "A2 is less than or equal to B2")

They can also be used in other logical functions like AND, OR and NOT, and even on their own.

There are three main operators:

The equal to. =

The greater than. >

The less than. <

They can be combined to do things like less than or equal to, greater than or equal to and not equal to, which is done by using <> together.

Comparison operators allow you to compare things. They are for checking if things are equal to or not equal to or greater than or less than. You would use them in logical situations, like checking if a score in an exam was high enough to be a pass. The standard operartors are:

= Equal to

<> Not equal to

< Less than

> Greater than

<= Less than or equal to

>= Greater than or equal to

The result of a comparison is always either TRUE or FALSE.

=10=10 will result in TRUE.

=5>=6 will result in FALSE

See the related question below.

It is any of the operators used to compare things to see if they are equal or greater than to less than etc. So ones like > < = are all comparison operators.

Equal to ( = )

Less than ( < )

Less than or equal to ( <= )

Greater than ( > )

Greater than or equal to ( >= )

Not equal to ( <> )

Lvl 1

Fart face

Q: What is the comparison operator used for not equal to in Excel?

Write your answer...

Submit

Still have questions?

Related questions

"≠" is used in mathematics, though because of the limitations of the Ascii character set then != is often used in programming. In Microsoft Excel, the comparison operator that means "not equal to" is either NOT, or <>.

No. Percent is not an operator, it is a symbol or cell format style.

The & is the concatenation operator. It could be used like this: =A1 & A2

comparison operators

In Excel, you use the asterisk, "*". As to the name, I would just call it the "multiplication sign".

It is any of the operators used to compare things to see if they are equal or greater than to less than etc. So ones like > < = are all comparison operators.

Depending on the comparison operator used, that's either an equation, or an inequality.

Excel does not change the year if the arithmetic operators have been used with the correct syntax.

Parentheses or round brackets ( and ) override operator precedence.

the asterisk is used for what function when building a formula in excel

False. Excel follows the rules of mathematics in doing calculations, as algebra also does.

Conditional operators are used to compare two values. The result of a comparison is either true or false. Boolean data types can hold the values true or false. Here's a list of operators. = Equal to > Greater than < Less than >= Grater than or equal to <= Less than or equal to <> Not equal to