I have attached an IF statement i made that is failing on certain pieces of data.
I may have constructed it incorrectly
The logic of the the IF is:
IF A2= FIT or FIJ and J2 = buy, leave O2 as it is
IF A2= FIT or FIJ and J2 = sel, multiply O2*-1
IF A2 = SIT and J2 = Buy, multiply o2*-1
IF A2 = SIT and J2 = sel, leave O2 as it is
I have attached the IF below