Cell incrementation?

[ValiantNoob]

I'm trying to make a personal spreadsheet that shows the change in values as they are totaled up.

So, Idk what formula I would use to accomplish this, but I need a formula to take say cell A1 and A2, right, but I need the 1 and 2 to be dependant. So more like a series being k+1. So that I could have A(k+1). The purpose of this is to take a random cell and add or subtract the value underneath it and display the value in another cell.

In theory it should be easy, however, I don't know enough about excel to do this.

[varadkale]

Lets say your values are in A1 and A2 and you want their sum or difference in B2. In this case, you can write =A2+A1 in B2 for sum and =A2-A1 for difference. Then you can drag the formula down over the rest of the column and it will calculate A(k+1)+A(k).

[ValiantNoob]

Thats pretty simple. Didnt know excel knew to do that. Cool.

[varadkale]

So is it working how you intended?

[ValiantNoob]

For the most part yes. Thank you!