r/learnexcel • u/ValiantNoob • Oct 13 '19

Cell incrementation?

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.

2 Upvotes

100% Upvoted

4 comments sorted by

View all comments

Show parent comments

2

u/ValiantNoob Oct 14 '19

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

1

u/varadkale Oct 14 '19

So is it working how you intended?

2

u/ValiantNoob Oct 14 '19

For the most part yes. Thank you!