Hi mcbee,
Thanks for the formula.
Here's what I'd like to do. A little more advanced than I earlier described.
I have 2 trigger blocks, one for Fav and one for Second Fav.
Bets as follows:The amount formula is only for the 2Fav
2Fav trigger 1st bet 4.00 2nd bet 10.00 subsequent bets 10% higher than previous bet
Fav trigger all bets 10.00
The triggers fire alternatively.
example
Nadal 2.30 4.00
Murray 1.70 10.00
Nadal 2.16 10.00
Murray 1.62 10.00
Murray 2.40 11.00
Nadal 1.50 10.00
Nadal 2.10 12.10
Murray 1.20 10.00
Nadal 3.60 13.31
The formula would need to ignore player as it is fav or 2fav related.
I started work on the below formula but needs quite a bit of modification.
IF(hist_1_backa>0,10+hist_1_backa*1.10,4)
Thanks again mcbee
R