Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: The Difference Between Numbers (Positive and Negative)

  1. #1
    Board Regular
    Join Date
    Nov 2004
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default The Difference Between Numbers (Positive and Negative)

    Hi folks,

    Hoping someone can help me quickly as I'm pulling my hair out and have a deadline getting too close.

    Been trailing the net and this board but can't work out how to do a simple variance.

    How do I work out the difference between two numbers - including negatives.

    If the numbers are all positive, it's fine as it's simply a case of A - B = C which is your difference. However, that doesn't work if B is negative.

    I need a formula that would give the following:

    First Number / Second Number / Difference
    1 / 5 / 4
    1 / -5 / -6
    -1 / 5 / 6
    -1 / -5 / -4
    -5 / -1 / 4

    Hopefully there's a simple function I've been missing.

    Thanks in advance, R
    Last edited by RTB3001; Jun 19th, 2011 at 07:20 AM.

  2. #2
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,255
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    2 Thread(s)

    Default Re: The Difference Between Numbers (Positive and Negative)

    Surely the second example should be

    1 / -5 / -6

    ...?

    In that case, C1 should be =B1-A1, filled down

    Denis
    Self-preservation: For when you've got yourself in a jam
    ------------------------------------------------------
    My site contains a number of Excel and Access Resources

  3. #3
    Board Regular
    Join Date
    Nov 2004
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: The Difference Between Numbers (Positive and Negative)

    Oops, yes you are correct. I've corrected it now.
    Really scratching my head on this one.
    R

  4. #4
    Board Regular
    Join Date
    Nov 2004
    Posts
    76
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: The Difference Between Numbers (Positive and Negative)

    Have I really just asked that?

    :-s

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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