Excel triggers multiple bets

[dafyddth]

Hello, hoping someone can help me. I have recently started using Betting Assistant with Excel triggered betting to place. (Excel 2013)

I have it set up to place a lay bet with an offset back bet using trigger: when a set of conditions is met, including no bet refs in Column T, checked by the formulas :=AND(T5<>"",T5<>"CANCELLED"), =AND(T6<>"",T6<>"CANCELLED") etc.


This all works. However it often triggers two or even three bets instead of just the one. Has anyone else come across this, and if so is there a solution? I am using a few lookups and formulas to get the required odds and so suspect that it triggers the bet before all the relevant cells are updated?

Thanks

[RobOrBob]

Perhaps I'm not following but your formula basically says "has a value other than cancelled".
So I assume you are using that to block further betting?

I'm not sure how you can get multiple bets accepted without using a CLEAR trigger anyway.

There is something in the back of my mind that says using the T5<>"" test caused me problems in the past and I preferred LEN(T5) > 0 instead.

I have in the past used a helper column in the worksheet to help decide if an existing bet reference needs to be cleared within my VBA processing.
If its any use to you the helper formula looks like this (1=to clear):
IF(ISNUMBER(IFERROR(VALUE(T5),"X")),1,IF(T5="CANCELLED",1,0)))

Hope this helps.