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]

or perhaps not using a recent version of Excel

If you checked the screen cap in post 3 you would see that this is not the case and that as I said, the array was not confirmed.

 

[rebel123]

I use Google Sheets

 

[rebel123]

Also, I don't think your formula worked, Yongle, because a lot of them said EVEN and they were not even

 

[rebel123]

I have no idea how to confirm or allign... even if the formula is super long... maybe we can all try again! sorry

 

[rebel123]

Here are where they are at now since i keep re-sorting them, as I am doing work on it now...

 

[rebel123]

So I manually wrote down both answers and for V2 and AH2, I was looking for the correct formulas.... Thanks!

 

[Yongle]

I have no idea what is going on here

 

[MARK858]

I have no idea what is going on here

I think that you may have missed post number 12

 

[Fluff]

@rebel123
When using software other than Excel, you need to clearly state that in you original post. You also need to post the question in the "General Discussion & Other Applications" section of the board.

 

[rebel123]

Oh OK- sorry I did not know. I have posted like 15 times on here and I never
mentioned it was Google Sheets, and every time the formula worked 100% correctly.

That was my mistake!