Results 1 to 5 of 5

Thread: <> (2003)

  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    <> (2003)

    Okay - I can't remember and can't find it - gave up and turned to ya'll

    What does <> mean in a formula?

    Thanks again

    Aunt Linda

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: <> (2003)

    Not equal to. It is the opposite of =.

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: <> (2003)

    Thanks - now I have to ask the REAL question

    What does <> do in the formula in the attachment?

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: <> (2003)

    The formula in C2:

    =SUMIF(A2:A7,"<>Jacket",B2:B7)

    adds the values of the cells in B2:B7 for which the corresponding cell in A2:A7 is not equal to Jacket. In this example, the formula adds B2, B3, B4, B5 and B7. B6 is excluded from the result because A6 contains Jacket. You can experiment by entering Jacket in one of the other cells in A2:A7, or by changing A6 to something different, and watching how C2 changes.

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: <> (2003)

    Thank you again, kind sir.

    Aunt Linda

Posting Permissions

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