HI All , first-of Peace and prosperity to you all...
Can anyone please tell me how to apply a matched bets condition on excel, because place a back or lay bet sometimes it trigger more then once by it self, so inorder to limit it to two matched bets ...how to do this guidance please.
Kindest Regards
Abel
HOW TO DO MATCHED BETS CONDITION ON EXCEL!?
any examples?...
"Just quickly, you need to look at Column T to AE, and put the desired conditions in an IF statement (probably)"
i thought this section for displaying an information of placed bets... is tere a away to limit the bets here?
I'm having a look at the count column in 'AB' and 'AE' for 'Matched back and Lay bet info' do you think maybe there is a particular IF formula you have provide then for this??
"Just quickly, you need to look at Column T to AE, and put the desired conditions in an IF statement (probably)"
i thought this section for displaying an information of placed bets... is tere a away to limit the bets here?
I'm having a look at the count column in 'AB' and 'AE' for 'Matched back and Lay bet info' do you think maybe there is a particular IF formula you have provide then for this??
You can add conditions to your condition statement.
So if it was
=IF(AND(C9>0,G9<2.3, H1 <> "in-play"),"BACK")
You could add a condition that Matched Back bets must be less than three, it might be
=IF(AND(C9>0,G9<2.3, H1 <> "in-play",AB9<3),"BACK")
Columns T to AE can be slowish to update so you may need to consider that, and/or dial up your refresh rate etc
So if it was
=IF(AND(C9>0,G9<2.3, H1 <> "in-play"),"BACK")
You could add a condition that Matched Back bets must be less than three, it might be
=IF(AND(C9>0,G9<2.3, H1 <> "in-play",AB9<3),"BACK")
Columns T to AE can be slowish to update so you may need to consider that, and/or dial up your refresh rate etc