Dutching the dogs

[dixiedean]

Hi All

I'm currently dutch betting on 2 dogs based upon rank position, however sometimes when the order changes it is placing a 3rd bet, is there a way to limit the amount of bets my excel sheet will place per race IE: only the 2 bets based upon rank at the time the trigger fires?

Thanks

D

[MarkRussell]

Hi,

You could put a formula in to count the number of bet refs in column T (i.e. the number of bets already submitted)
e.g. in T3 you could put =COUNTA(T5:T10)

Then assuming the first 2 bets are submitted at the same time, in the trigger column you could use in IF statement to check if T3 equals 0
e.g. =IF(T3=0,"BACK","")
So after the first 2 bets are submitted T3 will be 2 and therefore no more bets can be submitted.

Regards,
Mark

[dixiedean]

Hi Mark

Thanks for the reply, i have entered the count in T3 but where do i enter the other formula?

Thanks in advance

D

[dixiedean]

Tried this in column q but it doesnt work?


=IF(AND(E$2="Not In Play",F$2<>"Suspended"),IF(AA5="BACK",IF(AND(Z5=A5,AG5="N",$AJ$5="Y"),AA5&AA$2,""),IF(AND(Z5=A5,AF5="N",$AJ$5="Y",$T$3=0,"BACK",""),)))

[Yorkie]

Your formula seems a bit complicated to me. Personally i'd just take the formula you already had in the trigger cell but start it with =IF($T$3>0,"",

This way you bypass everything if there are any bet refs at all.

Yorkie

[MarkRussell]

Hi,

What Yorkie said is probably the best approach.

Regards,
Mark