Thanks:  0
Likes:  0

# Thread: The Difference Between Numbers (Positive and Negative)

1. ## 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.

2. ## 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

3. ## 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. ## Re: The Difference Between Numbers (Positive and Negative)

Have I really just asked that?

:-s

## User Tag List

#### Posting Permissions

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