Another CANCEL question....

[easternpromise]

Hi All,

I need help with my excel formula..... (i don't know how to use macros, that's why i'm trying this with formula)

What i trying to do is place a lay offfset bet, clear the Q column, if the odds go against me, CANCEL the unmatched offset part, and place another back bet.

My new BACK bet has a different stake, hence me not using the normal stoploss feature.

Below is the formula that I am working on, but i don't know how to add the CANCEL feature. Can you help.


=IF(T5>0,"CLEAR",IF(AND($E$2="Not In Play",$S$1<5,$F$2<>"Suspended"),LAY-TL-IPC,IF(AND(VLOOKUP(A5,MyBets!$B$2:$F$5000,4,FALSE)="U",VLOOKUP(A5,MyBets!$B$2:$F$5000,5,FALSE)="B",$E$2="In Play",H5<=1.5),"BACK-IP",""))))