A few questions regarding my excel

Discussion regarding the spreadsheet functionality of Bet Angel.
Post Reply
luck7
Posts: 72
Joined: Fri Jan 08, 2010 7:22 pm

Hi wondering if you could help me write out this command .

- I need excel to place a back bet for me only in games in which there is a 2 goal difference
ie : 2-0 , 3-1 , 4-2 ...

- placing a back bet after it has reached a certain odds

- synchronize the back bet to activate only 20 seconds after it has reached the odds .

Is it possible to combine these 3 terms into one command ?

I would be gratefull for any help . Thanks
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

Hi Luck

I've attached a spreadsheet with a formula that should do what you want. The formula appears twice, but with the second one I've named the cells, so it should be easier to see whats going on.

If (in this example) teamA is beating teamB (or vice versa) by >=2 goals, and the time is greater than 19 and the min odds are>=2, then you'll get a positive. Changing any of the values so they don't meet what you've specified, will result in a 0.

Hope this helps.
Nigel
Combine IF OR AND.xls
You do not have the required permissions to view the files attached to this post.
luck7
Posts: 72
Joined: Fri Jan 08, 2010 7:22 pm

Thanks alot nigel for your help.
I'll check that out any problems i'll get back here.
Again many thanks to you ...
luck7
Posts: 72
Joined: Fri Jan 08, 2010 7:22 pm

Some questions ...
How do I combine a live score site with Excel?
How do I put a timer?
nigelk
Posts: 469
Joined: Wed Apr 15, 2009 11:00 pm

HI Luck

Not sure about the live score part, but I've attached a timer.

Enter a number in cell F4, and it will count up to that number (in H4), and then re-set.

Nigel.
You do not have the required permissions to view the files attached to this post.
luck7
Posts: 72
Joined: Fri Jan 08, 2010 7:22 pm

How can I automatically start the timer when the first two conditions are in place?
Post Reply

Return to “Bet Angel - Spreadsheet / Excel chat”