not equal to symbol in excel

G

Guest

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

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Alt codes 4
Symbol 6
vba macro that allows insertion of symbols at cursor 0
Does Excel have a less than or equal to symbol? 3
Greater Than Symbols and calculations 0
Currency Symbol 2
Excel formula ^ 1
Excel Symbol 2

Top