stop betting at "suspended"

[crichton]

Hi, I'm new to Excel but have got it placing triggered lays correctly.

Only problem is, bets continue to be placed when the race turns "in-play".

Is this the default position and if so, how can I "un-default" it?

Thanks for any help!

[GaryRussell]

You need to control this yourself, for example the following formula only puts lay in the trigger column if the market is not in play.

=IF($E2="Not In Play","LAY","")

[crichton]

Just what I was looking for, many thanks.