Excel: Is there an INPLAY command ?

[essex_boy]

And how do I use it ?

[jimibt]

Cell G1 on the Bet Angel sheet references the In-play status. Depending on your use, you would examine this, plus cell H1 (which flags if the event has been suspended).

the combo of these should allow you to do what you need to do in a variety of combinations.

[essex_boy]

Ok how would I include it in is statement

=IF(G9<=5,"BACK","")

I dont want this command to come to life until INPLAY for around 5 seconds...

[jimibt]

Ok how would I include it in is statement

=IF(G9<=5,"BACK","")

I dont want this command to come to life until INPLAY for around 5 seconds...

you can monitor the countdown to give you this information -cell F4 on the Bet Angel sheet. you then look at G1 and F4 to derive your boolean TRUE value, then off to the races...