More of IF(AND
Hi Peter
I am not a gambling man myself, other than the odd flutter on the Derby or
Grand National, under the British Odds system.
Therefore, forgive me if I do not understand the way that the Decimal system
works.
I cannot see how you get to a result of 3.95 on a stake of 5.00 when the
horse came third.
I assume that it is an each way bet - in which case 2.50 is forfeit as the
horse did not win.
The 2.50 bet for a place, would normally be paid out at some fraction of the
odds, say 1/4.
The decimal system, as I understand it, would therefore work as follows
1.79 - 1.00 = 0.79
0.79 / 4 = 0.1975
1.0 + 0.1795 = 1.1795 * stake of 2.50 would result in a payout of 2.99 as
opposed to your 3.95
If you can explain how it works, then I am sure we can come up with some
formulae for you to calculate your P&L
--
Regards
Roger Govier
"Thurlow" wrote in message
...
Hello Bob
Thanks for responding
Column D = Runners - say 10
Column G = Price - say 1.79
Column J = Result - say 3
Column K = Stake - say 5.00
Column N = P&L on the result - in this case 3.95
I hope this helps
Many thanks
Peter
"Bob Phillips" wrote:
How is the data laid out?
--
__________________________________
HTH
Bob
"Thurlow" wrote in message
...
Hello
I have been battling with this problem for some time. I am a horse
racing
fan, I want to record my bets in a P&L account.
I cannot work out how to express the place, I believe this is known as
a
show in the USA & Australia.
The relevant parts of my spreadsheet a
Runners Odds Position Stake P&L
The formula I am trying to create is this.
If there are 7 runners or less I get paid on position 1 & 2
If there are 8 runners and less than 15 I get paid on position 1,2 &3
If there are more than 16 runners I get paid on position 1,2,3, &4
Anything outside of that you lose your stake.
I have tried =IF(AND, =IF(OR but I just cant get it to work.
I use a betting exchange so the odds are expressed as a decimal i.e,
evens
(1/1) is expressed as 2.0 and I use Excel 2003.
If anyone can help it would save the hair I have left! :-)
Many thanks
Thurlow
|