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

Is this what you want:

=IF(OR(D2="B"),(H2-E2),IF(OR(D2="S"),(E2-H2)))


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45752

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


"JBeaucaire" wrote:


Is this what you want:

=IF(OR(D2="B"),(H2-E2),IF(OR(D2="S"),(E2-H2)))


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45752

A little more help please?


=IF(OR(I2=6,"BE"),IF(OR(I26,6),IF(OR(I2<6,0)
--
DTrader


"JBeaucaire" wrote:


Is this what you want:

=IF(OR(D2="B"),(H2-E2),IF(OR(D2="S"),(E2-H2)))


--
JBeaucaire
------------------------------------------------------------------------
JBeaucaire's Profile: http://www.thecodecage.com/forumz/member.php?userid=73
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=45752

=IF(OR(I2=6,"BE"),IF(OR(I26,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
---

What to give this a shot?

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


"Max" wrote:

=IF(OR(I2=6,"BE"),IF(OR(I26,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" wrote:
=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
---

THANK YOU MAX, YOU & JBeaucaire MADE MY DAY!

I CAN RESEARCH TO MY HEARTS CONTENT!
--
DTrader


"Max" wrote:

"DTrader" wrote:
=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
---

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)
--
DTrader


"Max" wrote:

"DTrader" wrote:
=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
---

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" wrote in message
...
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)

THANKS A MILLION
--
DTrader


"Max" wrote:

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" wrote in message
...
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)

Welcome
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:22,000 Files:370 Subscribers:66
xdemechanik
---
"DTrader" wrote in message
...
THANKS A MILLION
--
DTrader