how to add 3 criteria for bullish,bearish,sideway in excel formula?

[gc7sdu]

i got below formula for 2 criteria but cannot get in 3 criteria. i want to set (bullish, bearish, side way) condition using excel formula. appreciate your advise.
=IF(OR(AND(G134>="up",H134<="down"),AND(G134<="down",H134>="up")),"bearish","sideway")

Thank you

 

[gc7sdu]

How about this?

PriceChangeFinal.xlsb
	E	F	G	H	I
134	Bullish		up	up
135	Side way		up	down
136	Side way		down	up
137	Bearest		down	down
Sheet3

Cell Formulas
Range	Formula
E134:E137	E134	=IF(G134<>H134,"Side way",IF(G134="up","Bullish","Bearest"))

Hi Cubist,

your formula is accepted by excel but the result showed different on the criteria above. H=3.97 is cell H133. H134=-10.98 was changes of index for previous day.

 

[Cubist]

There were mention of H being numerical before. What does “up/down” in H mean? Show the expected result in the next column.

 

[gc7sdu]

Hi Cubist,

your formula is accepted by excel but the result showed different on the criteria above. H=3.97 is cell H133. H134=-10.98 was changes of index for previous day.

View attachment 109997

There were mention of H being numerical before. What does “up/down” in H mean? Show the expected result in the next column.

up/down in G column is changes of F cell(previous day - next day). while H column is changes of index (previous day- next day). so these 2 criteria determine the market situation on that day.

 

[Cubist]

Looking at your example I don't get why they're all Side way.
Tuesday is UP ; Index change of 7.95 so should be Bullish?

 

[gc7sdu]

Looking at your example I don't get why they're all Side way.
Tuesday is UP ; Index change of 7.95 so should be Bullish?

i adopt your formula in the excel so it came out all "sideway". this why i need your advise. Since i started 7.95 is 1 April index so i didn't have 31 March index on hand.

 

[Cubist]

Can you show what the EXPECTED result should be mannually? Don't want to keep guessing what you want.

 

[gc7sdu]

There were mention of H being numerical before. What does “up/down” in H mean? Show the expected result in the next column.

please see I column for the expected market results.

Thank you

 

[Cubist]

Book3
	G	H	I
132		7.95
133	Up	3.97	Bullish
134	down	-10.98	Bearish
135	down	16.23	Side way
136	Up	-2.01	Side way
137	down	-6.47	Bearish
Sheet4

Cell Formulas
Range	Formula
I133:I137	I133	=CHOOSE((G133="Up")+(H133>0)+1,"Bearish", "Side way", "Bullish")

 

[gc7sdu]

Book3
	G	H	I
132		7.95
133	Up	3.97	Bullish
134	down	-10.98	Bearish
135	down	16.23	Side way
136	Up	-2.01	Side way
137	down	-6.47	Bearish
Sheet4

Cell Formulas
Range	Formula
I133:I137	I133	=CHOOSE((G133="Up")+(H133>0)+1,"Bearish", "Side way", "Bullish")

Hi Cubist,

These 2 highlighted red have not matched when index dropped compared with previous day on I column (7.95-3.97),(16.23-2.01). Result for these should be "Bearish". Appreciate yours advise on how to put in good formula. Thanks

 

[Cubist]

If you're comparing from previous day Tue is UP and Index change is DOWN from 7.95 to 3.97. With your criteria it should be Side way. Why Bearish?