Muliple formula conditions

[DTrader]

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

 

[DTrader]

Yes, thanks! that did the trick. I may have more...

 

[DTrader]

A little more help please?


=IF(OR(I2=6,"BE"),IF(OR(I2>6,6),IF(OR(I2<6,0)

 

[Max]

=IF(OR(I2=6,"BE"),IF(OR(I2>6,6),IF(OR(I2<6,0)

Try it as: =IF(I2<6,0,IF(I2=6,"BE",6))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:65
xdemechanik
---

 

[DTrader]

What to give this a shot?

=IF(I2<6,-8)*IF(I2=6,-4,)*IF(I2=7,-4)*IF(I2=8,"BE")

 

[Max]

=IF(I2<6,-8)*IF(I2=6,-4,)*IF(I2=7,-4)*IF(I2=8,"BE")

Try: =VLOOKUP(I2,{0,-8;6,-4;8,"BE"},2)

Suggest that you post formula queries in .worksheet.functions,
which is a more appropriate group
Keep it to one specific query per new post
Put in as many (new) posts as you may have specific queries (don't continue
asking new queries in the same thread after your original query has been
answered)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---

 

[DTrader]

THANK YOU MAX, YOU & JBeaucaire MADE MY DAY!

I CAN RESEARCH TO MY HEARTS CONTENT!

 

[DTrader]

this formula results with a -8 instead of 0 and invalidates the column total
any help?

=VLOOKUP(I7,{0,-8;6,-4;8,"BE"},2)

 

[Max]

What is the value in I7 ? And what should that value return ?

The vlookup merely embeds the assumption from your earlier criteria:
IF(I2<6,-8
where it was assumed that values in col I >= 0 and < 6
should return -8

If you actually want I7 to return zero if it is zero or blank,
use this: =IF(I7=0,0,VLOOKUP(I7,{0,-8;6,-4;8,"BE"},2))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik

 

[DTrader]

THANKS A MILLION
--
DTrader

What is the value in I7 ? And what should that value return ?

The vlookup merely embeds the assumption from your earlier criteria:
IF(I2<6,-8
where it was assumed that values in col I >= 0 and < 6
should return -8

If you actually want I7 to return zero if it is zero or blank,
use this: =IF(I7=0,0,VLOOKUP(I7,{0,-8;6,-4;8,"BE"},2))
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik

 

[Max]

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik