+ Reply to Thread
Results 1 to 7 of 7

not equal to symbol in excel

  1. #1
    amit
    Guest

    not equal to symbol in excel

    What is the symbol for not equal to in excel

  2. #2
    Arvi Laanemets
    Guest

    Re: not equal to symbol in excel

    Hi


    <>


    Arvi Laanemets


    "amit" <[email protected]> wrote in message
    news:[email protected]...
    > What is the symbol for not equal to in excel




  3. #3
    Armadillow
    Guest

    Re: not equal to symbol 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

    >
    >
    >


  4. #4
    Adam Kroger
    Guest

    Re: not equal to symbol 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

    >>
    >>
    >>




  5. #5
    Gord Dibben
    Guest

    Re: not equal to symbol 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

    >>
    >>
    >>


  6. #6
    Armadillow
    Guest

    Re: not equal to symbol 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
    > >>
    > >>
    > >>

    >


  7. #7
    Fred Smith
    Guest

    Re: not equal to symbol 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
    >>>
    >>>
    >>>

    >
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1