HELP please with some simple commands to add to my rule

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
User avatar
tootatoota
Posts: 56
Joined: Fri Apr 17, 2020 2:33 am

Hi Everyone,
I have been mucking around with excel for a little bit now but are very much a Novice.
I have a rule which i got from Betfair which i need some help in editing.The rule so far is
=IF(
AND(

Overrounds1<UserOverround,
TimeTillJump1<UserTimeTillJump,
ISBLANK(InPlay1)),
BACKLAY,
""
)

The problem is i do not know how to add the arguments i want to this rule?
basically when AK9>0 lay,then or if AM9>0 GREEN,Take profit if D10>2, and a Safety GREEN 10 secs beforeOFF
Would someone be kind enough to lend a couple of minutes and i will send you a PM.
Hoping in advance i will be very Appreciative.
Regards Toota
sphilipmyer
Posts: 40
Joined: Sun Oct 13, 2019 6:23 pm

How = if / and works is

=if(and(

two or more conditions are tested for),

then if true give the cell this value for example "LAY",

or if not true give the cell an alternative value eg "" )
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”