Stop excel when going inplay

[nagger]

hi

I am just using a simple trigger =IF(F20<=5,"BACK","") 5 mins before the off, but when going inplay its still placing the bet if not matched before.

Do i need to add anything to stop this as I just want the bet placed before the off.

Many thanks

[mak]

try

=IF(AND($E$2="Not In Play",F20<=5),"BACK","")

* drag down to all f column if need

[nagger]

Thanks for your quick reply