Thank you!! (I thought there would be a simple solution)

"Sheeloo" wrote:

Enter the formula in D3
Select D3
Choose Edit-Copy
Select from D3 down to the last cell in Col D
Choose Edit-Paste

"jlk" wrote:

Thank you, I do plan to use D3. However my sheet is hundreds of rows long. I
wish to enter one formula for the whole sheet, not in each row. How to do?


"Sheeloo" wrote:

You can not use the value in the same cell containing the formula

You can have this in D3
=C3-C4 to get the difference, between C3 and C4, in D3

"jlk" wrote:

For each row of data, I want to display the difference between the value in
cell C of the current row, and C in the next row. eg where "x" is the
current row:
=SUM (C(x+1), -Cx)

How do I create this formula ?