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