View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
DTrader DTrader is offline
external usenet poster
 
Posts: 7
Default Muliple formula conditions

I am a day trader doing trading system research.

I can't get a formula to work out on both sides for a positive result

=IF(OR(D2,1),(H2-E2),IF(OR(D2,2),(E2-H2)))

I would also like 'D' to calculate based on it's letter entry, B/S
=IF(OR(D2,B),(H2-E2),IF(OR(D2,S),(E2-H2)))

D E F G H
I
B/S Entry Drawdown Ticks Hi/Lo Ticks
S 1357 1357.75 0.75 1355 -2.00
B 1354 1357 3.00 1358 4.00