Hi
Can anyone please explain where and how to put the (fill or kill:true false)
into a spreadsheet.
For example in L9
I have =IF(G9<4,"BACK","") which works perfectly.
Excel Help
-
- Posts: 3140
- Joined: Sun Jan 31, 2010 8:06 pm
What do you mean all of the formula?
If G9 is 3 then that's less than 4 so the IF statement is true and it should display
I'm assuming you've done a typo as there should be a space between TRUE AND KILL
If G9 is 3 then that's less than 4 so the IF statement is true and it should display
Code: Select all
BACK FILL_KILL:TRUEKILL_DELAY:10
Code: Select all
=IF(G9<4,"BACK FILL_KILL:TRUE KILL_DELAY:10","")
Thanks SB
Seems to be working ok.
Just as an afterthought, what I do sometimes is log into practice mode
load up race/s into excel.
Log out. Keep excel open and manually change the BA spreadsheet
to see its effect on spreadsheet eg firing bets in etc
Makes it more leisurley to check its functionality.
Seems to be working ok.
Just as an afterthought, what I do sometimes is log into practice mode
load up race/s into excel.
Log out. Keep excel open and manually change the BA spreadsheet
to see its effect on spreadsheet eg firing bets in etc
Makes it more leisurley to check its functionality.
-
- Posts: 575
- Joined: Wed Apr 19, 2017 5:12 pm
- Location: Wolverhampton
=IF(G9<4,"BACK FILL_KILL:TRUEKILL_DELAY:10","")
Becomes...
=IF(AND(G9<4,AG9=x),"BACK FILL_KILL:TRUEKILL_DELAY:10","")
Just replace the bold part of the first example with the extended parameters you wish to include, ensuring the whole thing is encased in brackets and the word AND is infront.
If you want to nest further IF's you need to do it like this...
=IF(A,"Outcome of A",IF(B,"Outcome of B",IF(C,"Outcome of C","")))
^Note how the brackets only close at the very end so keep a count of how many you need.
Which means: if A, do outcome of A else, if B, do outcome of B else, if C, do outcome of C else do nothing. You just keep adding them on like this. Hope that answers your question!
Becomes...
=IF(AND(G9<4,AG9=x),"BACK FILL_KILL:TRUEKILL_DELAY:10","")
Just replace the bold part of the first example with the extended parameters you wish to include, ensuring the whole thing is encased in brackets and the word AND is infront.
If you want to nest further IF's you need to do it like this...
=IF(A,"Outcome of A",IF(B,"Outcome of B",IF(C,"Outcome of C","")))
^Note how the brackets only close at the very end so keep a count of how many you need.
Which means: if A, do outcome of A else, if B, do outcome of B else, if C, do outcome of C else do nothing. You just keep adding them on like this. Hope that answers your question!