General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
I've got a spreadsheet on the go and I've got a new column which I'm trying to increase a cell by a percentage, then increase the cell below using the new figure by the same percentage and so on. I've tried a few things but can't work it out.
i.e: £10.00 by 2% = 10.20, next cell £10.20 by 1% = £10.40..
cheers.
i.e: £10.00 by 2% = 10.20, next cell £10.20 by 1% = £10.40..
cheers.
Show More
Edit: .e: £10.00 by 2% = 10.20, next cell £10.20 by 2% = £10.40..
I'll assume you've got your £10.00 figure in cell A1.
In cell A2 enter =A1*1.02
Copy the formula down as required.
You should see something like this......
In cell A2 enter =A1*1.02
Copy the formula down as required.
You should see something like this......
| £10.00 |
| £10.20 |
| £10.40 |
| £10.61 |
| £10.82 |
| £11.04 |
| £11.26 |
| £11.49 |
| £11.72 |
| £11.95 |
| £12.19 |
| £12.43 |
| £12.68 |
| £12.94 |
| £13.19 |
| £13.46 |
| £13.73 |
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539