i want to create a spreadsheet (NEVER done this before - Brand new to
Excel) that will take a number, say 500 and increase it by 105%, then
take that number - 525 and increase it by 105% - 551.25 and so on and
so forth for 1,000 calculations. Any help you are able to provide is
greatly appreciated.
Piece of cake:
First put 500 in, say, Cell A1.
If you just want the final result, enter this in A2:
=A1*(1.05)^1000
which means multiply the value in A1 by 1.05 raised to the 1000th power.
If instead you want to see each of the intermediate steps, enter the
following formula in A2:
=A1*105%
or, equivalently,
=A1*1.05
Copy that cell 1000 times. Two ways:
1) Hover your mouse over the lower right corner of A2 until you see the
cursor change to the "fill handle" (looks like a box with arrows at the
upper left and lower right corners). Click, and without releasing the
mouse button, drag down to cell A1001. XL will adjust all the row
references.
2) Select cell A2 and choose Edit/Copy (or type CMD-C). Enter "A3:A1001"
(without quotes) in the Name Box, which is at the left end of the
Formula Bar. type Enter to select those cells, then choose Edit/Paste.
Again, XL will adjust all the row references.
