=IF(C9="S",(D9-F9),(F9-D9))
What I'm trying to accomplish is if I am "short", 'C" column, a contract,
then subtract my exit price, 'F' column, from my entry price, 'D' column. If
I am not "short", then I would like to subtract D from F. As I have this
function written, the answers it shows are not the answers to the equations
in paranthesis but the first value in the equations i.e. if C9 does equal S
then the answer given is D9 not D9-F9
Excel 2002 (10.2614.2625)