What is the symbol for not equal to in excel
What is the symbol for not equal to in excel
Hi
<>
Arvi Laanemets
"amit" <[email protected]> wrote in message
news:[email protected]...
> What is the symbol for not equal to in excel
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.
"Arvi Laanemets" wrote:
> Hi
>
>
> <>
>
>
> Arvi Laanemets
>
>
> "amit" <[email protected]> wrote in message
> news:[email protected]...
> > What is the symbol for not equal to in excel
>
>
>
Ive always used the NOT(A1=B1) function, as the <> does not work for me
either.
"Armadillow" <[email protected]> wrote in message
news:[email protected]...
>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.
>
> "Arvi Laanemets" wrote:
>
>> Hi
>>
>>
>> <>
>>
>>
>> Arvi Laanemets
>>
>>
>> "amit" <[email protected]> wrote in message
>> news:[email protected]...
>> > What is the symbol for not equal to in excel
>>
>>
>>
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
On Sun, 4 Dec 2005 11:22:02 -0800, "Armadillow"
<[email protected]> wrote:
>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.
>
>"Arvi Laanemets" wrote:
>
>> Hi
>>
>>
>> <>
>>
>>
>> Arvi Laanemets
>>
>>
>> "amit" <[email protected]> wrote in message
>> news:[email protected]...
>> > What is the symbol for not equal to in excel
>>
>>
>>
Gotta. I mispoke. All depends upon what OP was referring to. Thanks for
the addittional information.
"Gord Dibben" wrote:
> 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
>
> On Sun, 4 Dec 2005 11:22:02 -0800, "Armadillow"
> <[email protected]> wrote:
>
> >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.
> >
> >"Arvi Laanemets" wrote:
> >
> >> Hi
> >>
> >>
> >> <>
> >>
> >>
> >> Arvi Laanemets
> >>
> >>
> >> "amit" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > What is the symbol for not equal to in excel
> >>
> >>
> >>
>
I don't know which version of Excel you have, but <> has always worked for me.
--
Regards,
Fred
"Adam Kroger @hotmail.com>" <adam_kroger<nospam> wrote in message
news:[email protected]...
> Ive always used the NOT(A1=B1) function, as the <> does not work for me
> either.
>
>
> "Armadillow" <[email protected]> wrote in message
> news:[email protected]...
>>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.
>>
>> "Arvi Laanemets" wrote:
>>
>>> Hi
>>>
>>>
>>> <>
>>>
>>>
>>> Arvi Laanemets
>>>
>>>
>>> "amit" <[email protected]> wrote in message
>>> news:[email protected]...
>>> > What is the symbol for not equal to in excel
>>>
>>>
>>>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks