by jrarmstrong » Sat Mar 24, 2012 4:21 pm
Hi,
I am trying to use the cancel trigger when a bet has been matched. When the MyBets sheet shows a bet has been matched I had thought the following formula would then cancel the remaining unmatched positions but it does not seem to work:
=IF(MyBets!K2=1,"CANCEL",IF(AND(COUNT(MyBets!K2),MyBets!K2=0),IF(AND(Z5=A5,AD5<>"",$AE$5="Y"),AA5 & AA$2,""),""))
Can anyone point out where I am goin wrong?
Thanks,
James