Trigger Assistance

[ArduaAdAstra]

Hi

This is the trigger I use:

=IF(AC5="Yes","LAY","")

How can I stop this trigger working In Play?

The Yes/No works from odds and therefore the "Yes" can trigger in play which is not what I want.

Thanks

[mak]

I think you could use something like this

=IF(AND(E2<>"In Play",F2="Suspended",AC5="Yes"),"LAY",""))

[MiniBlueDragon]

I use similar to mak:

Code: Select all

=IF(AND(E2="Not In Play",AC5="Yes"),"LAY",""))

Intrigued by the Suspended part though mak; what does it do?

[ArduaAdAstra]

Thanks folks!
We are operational.