difference between two cells with negative/positive numbers

[vitamin]

Hello all,

I am trying to find the formula to give me the difference between two cells that contain negative numbers.

Sorry if this is VERY 101. ://

I have tried the =abs with no success and think I'm barking up wrong tree.

i.e. cell A1 contains -10 and cell A2 contains -1 , in this case difference would be -9 ... whats the formula???

Thanks!

 

[vitamin]

#duh got it.. ://

=SUM(A1-A2)

 

[cyrilbrd]

=A1-A2 would have suffice, no?

 

[vitamin]

=A1-A2 would have suffice, no?

yep...mild mind fart....thanks cyribrd.

 

[cyrilbrd]

No worries, glad you got it anyway.