excel help

[bricklayer]

hi, this is my first post and im currently using this software on my trial period,
first impressions looks good.

just wondering how to put a condidion statement in excel similar to the built-in one in the software?

im running v.1.1.0.65z9a
im also trying this trigger BACK-T10-SL20-L-SLC1-IP in the trigger cell.
i would like to add a condition in the odds cell so that it only triggers the bet when the odds drop to around say 1.9, obviously it backs the current availiable price as this is higher than what im after.

[GaryRussell]

"-SLC1" is not supported in the version you are using. You need to to upgrade to the Beta version. See http://gruss-software.co.uk/forum/viewtopic.php?t=6623

You need to use a formula in the trigger cell to make it conditional so that the trigger is only populated when the condition is met.

eg. if your trigger is in cell Q5 the formula below will only fire the trigger if the back odds in column F are less than or equal to 1.9.

Code: Select all

=IF(F5<=1.9,"BACK-T10-SL20-L-SLC1-IP","")

[bricklayer]

thanks Gary,
i will try that.