Hi guys,
Can someone help? I am not that great with excel but learning slowly. What i have set up is a couple of simple if statement triggers, If they are not matched before the off then i don't want the bet firing. The race is going inplay and the triggers are still active.
Can anyone help me with the formula that would disable the trigger inplay?
cheers in advance
Excel trigger help
Moderator: 2020vision
3 posts
• Page 1 of 1
Excel trigger help
by jmini123 » Sat Feb 27, 2010 6:10 pm
- jmini123
- Posts: 16
- Joined: Thu Jul 10, 2008 1:15 am
- Location: north yorks
by silver » Sat Feb 27, 2010 6:32 pm
You can add in a reference to the E2 cell like this:
$E$2="Not In Play"
I can't write the full formula without knowing what your other criteria are, but you could embed it as an IF clause in the rest of your formula using AND like this:
=IF(AND(yourcriterion1,yourcriterion2,$E$2="Not In Play"),"BACK","")
As long as you don't use the -IP trigger modifier, any bets which are triggered prior to In Play but not matched immediately, will not be matched during In Play.
$E$2="Not In Play"
I can't write the full formula without knowing what your other criteria are, but you could embed it as an IF clause in the rest of your formula using AND like this:
=IF(AND(yourcriterion1,yourcriterion2,$E$2="Not In Play"),"BACK","")
As long as you don't use the -IP trigger modifier, any bets which are triggered prior to In Play but not matched immediately, will not be matched during In Play.
- silver
- Posts: 42
- Joined: Thu Sep 03, 2009 10:50 am
- jmini123
- Posts: 16
- Joined: Thu Jul 10, 2008 1:15 am
- Location: north yorks
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: Google [Bot] and 74 guests