not equal to symbol in excel

A

Armadillow

I disagree. Those symbols mean less than and greater than.
Go to your Insert dropdown menu-->Symbol ≠...this is the equal sign with a
slash through it. When you click on it, the "Code" or "definition" will show
up on the left side of the box.
 
G

Gord Dibben

Interpretation is the problem here, as I see it.

For purposes of calculation operations the comparison operator <> means not
equal.

For purposes of "Symbol" the slashed = sign is correct.

All depends upon what OP was referring to.


Gord Dibben Excel MVP
 
A

Adam Kroger

Ive always used the NOT(A1=B1) function, as the <> does not work for me
either.
 
A

Armadillow

Gotta. I mispoke. All depends upon what OP was referring to. Thanks for
the addittional information.
 
F

Fred Smith

I don't know which version of Excel you have, but <> has always worked for me.
 
Top