Hi to all Betangel users
I may have set up the excel script incorrectly
as it doesn't seem to place the bet either before or inplay the race
"IF(G11<1.40,"BACK","")
When you select the odds to back and the stake value
To the right where it should be empty or showing PLACED it shows ERROR
Any ideas as I am stuck at the moment?
richard.b747
Excel Spreadsheet
-
richard.b747
- Posts: 7
- Joined: Fri Jul 30, 2010 10:32 pm
Thanks for the reply, no error message just
The word ERROR in the cell which should show PLACED when the bet has taken
Many thanks
The word ERROR in the cell which should show PLACED when the bet has taken
Many thanks
-
dimplehouse
- Posts: 5
- Joined: Tue Jul 13, 2010 9:20 pm
I think the cell contents should read:
=IF(G11<1.40,"BACK","")
Not sure where the first " came from:
"IF(G11<1.40,"BACK","")
=IF(G11<1.40,"BACK","")
Not sure where the first " came from:
"IF(G11<1.40,"BACK","")
-
richard.b747
- Posts: 7
- Joined: Fri Jul 30, 2010 10:32 pm
Many many thanks for all your help!
Just trying to build on it now. I was literally tearing my hair out trying to make it work!
It's a scary business these Excel formulas, but when you get more confident with it I am sure it will work out ok.
Just didnt want to see the pot disappear before my very eyes! ha ha. Yea, I know its easy enough to do that anyway.
Thanks again, no doubt I will be asking about the next stage soon.
Richard.
Just trying to build on it now. I was literally tearing my hair out trying to make it work!
It's a scary business these Excel formulas, but when you get more confident with it I am sure it will work out ok.
Just didnt want to see the pot disappear before my very eyes! ha ha. Yea, I know its easy enough to do that anyway.
Thanks again, no doubt I will be asking about the next stage soon.
Richard.