I hope this is easy, I just don't know how.
My spreadsheet has 1.04 in cell D2. It has 24000 in cell D3. My cells go all the way down to D37. I can create a formula for cell D4, for example, that increases D3 by 4%: ROUND(D3*D2). So D4= 24960.
And so on, cell D5 increases cell D4 by the 1.04: ROUND(D4*D2). So D5= 25958, and so on.
This feels like there has got to be a way to automate this - instead of repeating the formula with its little cell number change for each and every cell, placing ONE formula statement somewhere for the whole procedure.
The point is to increase each cell by a fixed percentage over the previous one. Can anyone teach me this? Thank you.
Bookmarks