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