We want to share an important update with our Betfair Community users.
Over the coming months, the Betfair Community platform will be winding down. The final active day for the platform will be December 21st. From December 22nd, users will no longer be able to access the platform.
Your discussions, insights, engagement, and, most importantly, feedback have helped shape the platform and guided innovation. Your feedback continues to be important to us, and we will continue to listen via our dedicated feedback channels, as well as through product testing and innovations.
To share your feedback and experience, visit: https://support.betfair.com/app/home
General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
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
Show More
click on the bottom right of the box, there should be a darker arrow
then draaaaaaaag
hope this makes sense
then draaaaaaaag
hope this makes sense
nonshy il tell you how if u tell me those websites in which i can get info on team news in lower leagues ;)
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!! :-)
master of multies... i don't deal in second rate football!! :-)
3rd column? You've only got one so far haven't you?
=a2-a1 ?
And then draaaaaaaaggg ?
=a2-a1 ?
And then draaaaaaaaggg ?
formula in first column isn't right... want 1% of balance... currently got =B3*1.01 (draaaaag)
but how do i get that to show for 365 days without inputting it manually?
Try it for 4 days first as a trial.
:-)
Try it for 4 days first as a trial.
:-)
: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
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
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
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
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539