a question of differences

[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

 

[Lewis Clark]

Use the same formula. Put in cell c1: = B1-A1

 

[Paul Sheppard]

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

Hi Amy

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

Paul