The Difference Between Numbers (Positive and Negative)

[RTB3001]

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

 

[SydneyGeek]

Surely the second example should be

1 / -5 / -6

...?

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

Denis

 

[RTB3001]

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

 

[RTB3001]

Have I really just asked that?

:-s