Forums

General Betting

There is currently 1 person viewing this thread.
Pass&Move
09 Jan 11 18:13
Joined:
Date Joined: 30 Jan 10
| Topic/replies: 489 | Blogger: Pass&Move's blog
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.

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
sort by:
Show
per page
Replies: 3
By:
Pass&Move
When: 09 Jan 11 18:16
Edit: .e: £10.00 by 2% = 10.20, next cell £10.20 by 2% = £10.40..
By:
top2rated
When: 09 Jan 11 18:45
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......

    £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   
By:
Pass&Move
When: 09 Jan 11 18:54
Cheers for that!
sort by:
Show
per page

Post your reply

Text Format: Table: Smilies:
Forum does not support HTML
Insert Photo
Cancel
‹ back to topics
www.betfair.com