a question of differences

A

AmyTaylor

I have a very basic function that looks at 2 sets of numbers and
calculates the difference between the first and second

eg: a1 = 5, b1 = 3, therefore c1 = -2
eg: a1 = 10, b2 = 15, c1 = 5

The problem comes with 2 negative numbers,
eg: a1 = -5, b1 = -15. I want c1 to equal -10
eg: a1 = 4, b1 = -1, I would want c1 to equal -5

Can someone help me with the formulae ?!

thanks

Amy xx
 
P

Paul Sheppard

AmyTaylor said:
I have a very basic function that looks at 2 sets of numbers and
calculates the difference between the first and second

eg: a1 = 5, b1 = 3, therefore c1 = -2
eg: a1 = 10, b2 = 15, c1 = 5

The problem comes with 2 negative numbers,
eg: a1 = -5, b1 = -15. I want c1 to equal -10
eg: a1 = 4, b1 = -1, I would want c1 to equal -5

Can someone help me with the formulae ?!

thanks

Amy xx
Click to expand...

Hi Amy

I've got excel 2000 and the formula =B1-A1 returns the values you are
expecting

Paul
 
Top