General Betting
Welcome to Live View – Take the tour to learn more
Start Tour
There is currently 1 person viewing this thread.
21 May 12
23:04
Joined:
Date Joined:
04 Apr 03
I am laying two events
- One is 1.80
- The other 2.80
- I want to win £60.00 if both successful
- I want equal risk between the two (thus laying at 2.3 average)
When I do the math 'manually', prior to commission, the figures come to:
£42 at 1.80
£18 at 2.80
In one cell, how do I get from £60 collective to 42 and 18 ?
- One is 1.80
- The other 2.80
- I want to win £60.00 if both successful
- I want equal risk between the two (thus laying at 2.3 average)
When I do the math 'manually', prior to commission, the figures come to:
£42 at 1.80
£18 at 2.80
In one cell, how do I get from £60 collective to 42 and 18 ?
Show More
Try ~
In Cell A1 enter 1st race div i.e. 1.8
In cell A2 enter 2nd race div i.e 2.8
In cell a3 enter profit required if both win i.e. 60.00
Copy this formula below and paste it into Cell B1:-
=(A3/(1/(A2-1))*(1/(SUM(A1:A2)-2)))*(A1-1)
Broken down, the formula result in B1 is the liability for each selection to lay at.
This will return a profit of what is in cell A3 (if both lays are successful)
Cheers.
In Cell A1 enter 1st race div i.e. 1.8
In cell A2 enter 2nd race div i.e 2.8
In cell a3 enter profit required if both win i.e. 60.00
Copy this formula below and paste it into Cell B1:-
=(A3/(1/(A2-1))*(1/(SUM(A1:A2)-2)))*(A1-1)
Broken down, the formula result in B1 is the liability for each selection to lay at.
This will return a profit of what is in cell A3 (if both lays are successful)
Cheers.
Cheers....will load it in after my third coffee.....
CM, thank you. Works perfectly. My variations weren't close.
Seven combinations done in three minutes.
Appreciated.
Seven combinations done in three minutes.
Appreciated.
Post Your Reply
Please login to post a reply.
Wonder
Instance ID: 13539