General Betting
There is currently 1 person viewing this thread.
Not something i know anything about...
If I have a bank of £500 and want to show 0.5% increase each day what formula i need?
Ie
Day 1
Day 2
Day 3
etc
etc
= a1*0.005
but how do i get that to show for 365 days without inputting it manually?
thanks
If I have a bank of £500 and want to show 0.5% increase each day what formula i need?
Ie
Day 1
Day 2
Day 3
etc
etc
= a1*0.005
but how do i get that to show for 365 days without inputting it manually?
thanks
sort by:
Show
per page
Replies: 11
|
By:
i know how to do it
|
|
By:
:D please go on...
|
|
By:
click on the bottom right of the box, there should be a darker arrow
then draaaaaaaag hope this makes sense |
|
By:
nonshy il tell you how if u tell me those websites in which i can get info on team news in lower leagues ;)
|
|
By:
TY rictus... if i wanted a third column to show actual amount required to achieve daily target what would that formula be?
master of multies... i don't deal in second rate football!! :-) |
|
By:
3rd column? You've only got one so far haven't you?
=a2-a1 ? And then draaaaaaaaggg ? |
|
By:
formula in first column isn't right... want 1% of balance... currently got =B3*1.01 (draaaaag)
|
|
By:
but how do i get that to show for 365 days without inputting it manually?
Try it for 4 days first as a trial. :-) |
|
By:
:D
This is what I am trying to achieve to start with!!! Starting bank: £500... making 0.5% a day Column1 --------- Column2 ----------------Column3 Day 1-------------- £502.50 ------------------ £2.50 Day 2-------------- £505.01 ------------------ £2.51 Day 3--------------- £507.54 ------------------ £2.53 etc etc |
|
By:
This is what I am trying to achieve to start with!!!
Starting bank: £500... making 0.5% a day Column1 --------- Column2 ----------------Column3 Day 1-------------- £502.50 ------------------ £2.50 Day 2-------------- £505.01 ------------------ £2.51 Day 3--------------- £507.54 ------------------ £2.53 So put 500.00 in cell B1 Day 1 in cell A2 - draaaaag =B1*1.005 in cell B2 - draaaag =B2-B1 in cell C2 - draaaaag |
|
By:
THANKS!!!!
Very much appreciated!!! |