Lay all and inplay

[dealbanker]

Hello
does anyone know how to write the excel formula for the following scenario...
I need program to trigger lay bets when:
any 2 horses of the field have back bet odds being asked are under 2.00 - lay all horses @ 2.00
any 3 horses where back bets being asked are under 3.00 - lay all horses @ 3.00
any 4... and so on up to 6

Thanks in advance if this is possible

shane

[dealbanker]

Edit
scenario should read as
any 2 horses...
or
any 3 horses
or
any 4

Not sure if this would be in a nested IF function or it needs separate sheets for each function, if Guss can do that

Shane

[Captain Sensible]

easy enough to program in excel using the countif function but you're wasting your time as Betfairs cross matching would mop up any bets well before you bsoecause the book would be overround, the only times it'd occur would be with a non runner when people were trying to manipulate the book

[dealbanker]

Thank you Captain

On the Betfair point, I have been doing it successfully (manually) using their horrible Rapid program... I am looking to automate it with Gruss

Thanks for the formula tip. I will go and learn about Countif

Regards
Shane

[dealbanker]

I have created the formula for this scenario...
does anyone know how to create a lay all spreadsheet?

shane