Formulas dealing with +/- changes

[Guest]

I have the need to create a formula dealing with the positive or negative change in cells:

Example:

cell 1: 2.7
cell 2: 2.1
cell 3: 4.2

cell 4: shold equal total change +/- between the above cells

Thanks for your help

Keith

 

[Andy B]

Hi

Do you mean the difference between the first and last? That would be cell
3-cell 1

 

[Guest]

Hi Andy,

What I'm actually looking for is the +/- difference between each cell.

Thanks

Keith

 

[Andy B]

OK

You say that you want it in one cell, though?

 

[Guest]

Yes

OK

You say that you want it in one cell, though?

 

[Guest]

Yes

OK

You say that you want it in one cell, though?

 

[Andy B]

Well, the total beween each cell is the same as the total between the first
and last cells:
2.7
2.1
4.2
Total diff =4.2-2.7 = 1.5

2.7
2.1 diff = -.6

2.1
4.2 diff = 2.1

2.1-.6 = 1.5

Andy

 

[Dave Peterson]

If you did it manually, what would that value be?

Yes