Another Excel Formula For Stocks (Positive, Negative, Or Even)

[rebel123]

Thanks for your help. Please post the formula in an equals formula, please
with the exact cell numbers also.

I am doing stock research and I wanted to find out
how what the answer is (where I can drag the formula down)
for rows T213 and T214.

The way the formula works is like this
$53,376 COMPARED TO $54,498 COMPARED TO $42,572 COMPARED TO $66,807

ANSWER FOR T213 is Up, Down, Up
(Because $53,376 went up to $54,498 & then went down to $42,572 & then went up to $66,807)


ANSWER FOR T214 is Up, Down, Even
(Because $200 went up to $500 and then went down to $100 and was that even with $100.

 

[jasonb75]

Array confirm in T213, then fill down.

=TEXTJOIN(", ",1,INDEX(CHOOSE(SIGN(O213:Q213-P213:R213)+2,"DOWN","EVEN","UP"),N(IF({1},{3,2,1}))))

 

[rebel123]

Sorry, I re-arranged my cells- now I am now on cell T308.

 

[rebel123]

But, this is the result I got.... I simply copy and pasted it and it reads
=TEXTJOIN(", ",1,INDEX(CHOOSE(SIGN(O213:Q213-P213:R213)+2,"DOWN","EVEN","UP"),N(IF({1},{3,2,1}))))

 

[rebel123]

I even changed the formula to the row, and it did not work... I tried this...

=TEXTJOIN(", ",1,INDEX(CHOOSE(SIGN(O308:Q308-P308:R308)+2,"DOWN","EVEN","UP"),N(IF({1},{3,2,1}))))

 

[Yongle]

The obvious way
... longer but easier to understand
=IF(R213<Q213,"UP",IF(R213>Q213,"DOWN","EVEN"))&","&IF(Q213<P213,"UP",IF(Q213>P213,"DOWN","EVEN"))&","&IF(P213<O213,"UP",IF(P213>O213,"DOWN","EVEN"))

Or if you want it for row 308
=IF(R308<Q308,"UP",IF(R308>Q308,"DOWN","EVEN"))&","&IF(Q308<P308,"UP",IF(Q308>P308,"DOWN","EVEN"))&","&IF(P308<O308,"UP",IF(P308>O308,"DOWN","EVEN"))

 

[rebel123]

Thanks Yongle. That is correct and I just followed you. It wasn't a space in between but I don't really care.
I typed and it said "UP,DOWN,UP" versus saying "UP, DOWN, UP"

=IF(R308<Q308,"UP",IF(R308>Q213,"DOWN","EVEN"))&","&IF(Q308<P308,"UP",IF(Q308>P308,"DOWN","EVEN"))&","&IF(P308<O308,"UP",IF(P308>O308,"DOWN","EVEN"))

 

[Yongle]

Put the space in yourself - it is not difficult to work it out
amend this bit twice
change "," to " , "

 

[jasonb75]

I even changed the formula to the row, and it did not work... I tried this...

=TEXTJOIN(", ",1,INDEX(CHOOSE(SIGN(O308:Q308-P308:R308)+2,"DOWN","EVEN","UP"),N(IF({1},{3,2,1}))))

That's because you didn't confirm the array.

 

[Yongle]

That's because you didn't confirm the array.

or perhaps not using a recent version of Excel

TEXTJOIN funtion is only available in ...
Excel for Microsoft 365
Excel for Microsoft 365 for Mac
Excel for the web
Excel 2019