Excel ,Global Commands ,Bet Rules

[StellaBot]

Hi

When I enter this statement, =IF(G9<3,BACK,"") , in L9 it works perfectly. Basically fires in a bet on fav if odds less than 3.
What im trying to do is put in a back offset OF 2 but dont know where to put the OFFSET statement and whether its in brackets and where its placed in above statement .Have tried =IF(G9<3,BACK OFFSET:2,"") and
=IF(G9<3,BACK ,[OFFSET:2],"").
Any help please.

[nigelk]

Try putting the whole command in brackets:

=IF(G9<3,"BACK OFFSET:2","")

[StellaBot]

Thanks for reply Nigel.
Is that not same as first one I quoted?
I will try tomorrow morning and feedback.
Thanks
Edit
Oh " " I see

Shouldve went to specsavers

[StellaBot]

Thanks nigelk
I understand your way.
Has to be a simpler way with BA to accommadate that.
I will post elsewhere.

[StellaBot]

Hi
next episode of excel here.
Thanks nigelk
Did try but I must ave messed up my original excel sheet.
Heres a question.
Can there be 1 excel sheet that loads and works for every horse race.
I am thinking of guardian where one "rule" can be applied for every race(market)
Not excel 1,excel 2,excel3 etc

[MemphisFlash]

have a look here

viewtopic.php?f=19&t=15873


https://youtu.be/b-YliIrp9QQ?list=PLmqu ... 1DmAlbbd4X

[StellaBot]

Hi Nigel
Soz about late reply.
My Laptop was left opened at party.
However.
Spot on thank you.
In brackets was correct ty..

I will try to ask Memphis a solution based on that now.
This is most complicated part for me.
Soz Memphis, also missed your reply.