Calculating Differences Uniformly


Hi,

I have a list of numbers:

2
-4
3
3
-45
-32

etc

I know from looking at the list the difference between the numbers is:

-6
7
0
-48
7

But I can't figure out what a short sweet formula is to calculate the
difference on the way down. If I say "A2-B1" and they are both negative
numbers it'll add them both as positive numbers instead of showing the
net change between the two numbers. If one is negative and the other is
positive, if I subtract the negative it turns positive on me, which
makes me, well, get pretty negative, lol

Any thoughts on this would be much appreciated

TIA!


--
tx12345
------------------------------------------------------------------------
tx12345's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24776
View this thread: http://www.excelforum.com/showthread.php?threadid=497105

.

Relevant Pages

  • Microsoft Natural Multimedia Keyboard
    ... TIA, ... DanyWu ... DanyWu's Profile: http://www.msusenet.com/member.php?userid=487 ... Prev by Date: ...
    (microsoft.public.win2000.general)
  • Re: math problem
    ... > TIA ... Morrigan ... Morrigan's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=7094 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Geld mit einfach verdienen! Habe es selbst getestet
    ... gaaanz duuurch *LOL* ... Stefano ... Stefano's Profile: http://www.aktienboard.com/vb/member.php?userid=414 ... Prev by Date: ...
    (de.etc.finanz.misc)
  • Re: Logic command IF/OR
    ... > The above formula gives me an error message, is it possible to do what ... > TIA ... > G_Chem's Profile: ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Please Help!!!!
    ... work, lol!!! ... Kind Regards ... Stuck_At_Work's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=30896 ... Prev by Date: ...
    (microsoft.public.excel.misc)