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

Muliple formula conditions
 

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

Muliple formula conditions
 

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

Muliple formula conditions
 

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

Muliple formula conditions
 

=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
---

Muliple formula conditions
 

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

Muliple formula conditions
 

"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
---

Muliple formula conditions
 

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

Muliple formula conditions
 

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

Muliple formula conditions
 

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)

Muliple formula conditions
 

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)

Muliple formula conditions
 

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