Thread: OR'ing to IF Statements
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
carl
 
Posts: n/a
Default OR'ing to IF Statements
I am trying to "OR" these together.

=IF(AND(H5="sell";K5<=D5);(K5-D5)*L5*100;(K5-D5)*L5*100)

=IF(AND(H6="buy";K6<=C6);(C6-K6)*L6*100;(C6-K6)*L6*100)

Thank you in advance.
Reply With QuoteReply With Quote