by Sussexguy44 » Mon Mar 20, 2023 6:30 pm
=IF($E$2="Not In Play",IF($Y36>=0.25,"CLOSE",IF(AND($Y$1<=30,$T5<>""),"CLOSE","")),"")
Hi Guys, Im using the above formula for closing the bets in a race. Y36 is the close/Profit Total and works OK. Y1 is the time converted to seconds. So I am looking to CLOSE the selection if either the profit is .25p or there is 20 or less seconds to go before the official start of the race. Does the formula look OK?
Cheers Dave