General Betting
There is currently 1 person viewing this thread.
25 1.05 26.25
26.25 1.05 27.5625
27.5625 1.05
Ok, As above I have multiplied 25 by 1.05 to get 26.25. i the want to multiply the resulting 26.25 by 1.05 again.
I want to repeat this over and over a number of times. How to I apply this formula in excel. Help much appreciated
26.25 1.05 27.5625
27.5625 1.05
Ok, As above I have multiplied 25 by 1.05 to get 26.25. i the want to multiply the resulting 26.25 by 1.05 again.
I want to repeat this over and over a number of times. How to I apply this formula in excel. Help much appreciated
sort by:
Show
per page
Replies: 4
|
By:
For an example, if your 25 is in A1, 1.05 is in B1 and in C1 you have "=A1*B1". In A2 put "=C1", then in B2 put "=B1" and finally put "=A2*B2" in C2.
Now copy cells A2, B2 and C2 and fill down as many rows as you want. If you want to change the 1.05 then you only need to change it in cell B1 and it will change every other row for you |
|
By:
Hi JTMTD1976,
Here is one way. In cell A1 enter 1, then click fill in the home menu, click series, click columns, in the stop value enter 100 or however many iterations you need, click ok. Copy this formula ~ =FV(0.05,A1,0,-25,1) Paste into cell B1 and then fill down. To fill down quickly, with your mouse select the bottom right hand corner in cell B1 and double click. If you wish results to account for commission at 5%, use this formula instead. =FV(0.0475,A1,0,-25,1) Cheers |
|
By:
cheers guys
|
|
By:
gals
|