HELP : excel triggering, how to cancel an unmatched bet ?

[benny2008]

Hello, I'm a newbie about BA.
I've made some excel sheets correctly working but now I've an hard ( for me ) question. I would like to make a sheet working in this way : place 2 bet ( doesn't matter if BACK or LAY ) and when one of these is matched, cancel immediately the unmatched one ( then absolutely no other bet in this race until the quick pick go to next one, then two bet, when one bet is matched, cancel the remaining one and so on ..)
How can I do it ?
Thanks for helping.Great software.

[Captain Sensible]

Easiest way is just to switch the trigger calc to cancel when it sees an amount appear in the matched stake column. A simple if statement will be enough. No further bets would be placed and the refs would clear on the auto select for the next race to let it continue betting.

[Captain Sensible]

Remember cancel need to be in uppercase

=IF(SUM(X5:X60)>0,"CANCEL","your usual betting routine")

You can change the value >0 to the stake column if you only want to cancel when all of the stake has been mached