General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
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
Show More
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
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
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
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
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539