Thread: IF function with value_if_true and value_if_false as equations
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
emrobertson
 
Posts: n/a
Default IF function with value_if_true and value_if_false as equations
=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)
Reply With QuoteReply With Quote