General Betting
There is currently 1 person viewing this thread.
For a simple person seeing as Excel is not my strong point.
I know how to formulate a backing spreadsheet, but looking for a laying formula.
H = Stake
I = Odds
J = Bookie
K = W/L
L = P/L
What I want to know is what should be in "L"
For example, I lay something @ 1.34 for £10. My liability is £3.40
Obviously if the lay is successfull, I win £10 minus commission.
If the selection wins, I lose £3.40
And is it possible to include the deduction of commission at 5%?
Anyone help?
Cheers.
I know how to formulate a backing spreadsheet, but looking for a laying formula.
H = Stake
I = Odds
J = Bookie
K = W/L
L = P/L
What I want to know is what should be in "L"
For example, I lay something @ 1.34 for £10. My liability is £3.40
Obviously if the lay is successfull, I win £10 minus commission.
If the selection wins, I lose £3.40
And is it possible to include the deduction of commission at 5%?
Anyone help?
Cheers.
sort by:
Show
per page
Replies: 3
|
By:
Insert the formula below in cell L2 =IF(K2"",IF(K2=1,H2*0.95,-(I2-1)*H2),"") | ||||||||||||||||||
|
By:
Usual problem displaying the less than and greater than characters
 I'll try again...... =IF(K2 < > "",IF(K2=1,H2*0.95,-(I2-1)*H2),"") | ||||||||||||||||||
|
By:
Cheers toprated, I've sorted it now.
|