Calculating Differences Uniformly

T

tx12345

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!
 
R

rsenn

Assuming the numbers are in column A starting in cell A1,

then in cell B2 use A2 - A1, and copy down.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top