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

rebel123

Active Member
Joined
Apr 18, 2017
Messages
345
Office Version
  1. 365
Platform
  1. MacOS
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.
 

Attachments

  • Screen Shot 2020-06-28 at 11.01.01 AM.jpg
    Screen Shot 2020-06-28 at 11.01.01 AM.jpg
    116.2 KB · Views: 12
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.
 
Upvote 0

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Also, I don't think your formula worked, Yongle, because a lot of them said EVEN and they were not even
 
Upvote 0
I have no idea how to confirm or allign... even if the formula is super long... maybe we can all try again! sorry
 
Upvote 0
Here are where they are at now since i keep re-sorting them, as I am doing work on it now...
 

Attachments

  • Screen Shot 2020-06-28 at 12.23.48 PM.jpg
    Screen Shot 2020-06-28 at 12.23.48 PM.jpg
    140.6 KB · Views: 5
  • Screen Shot 2020-06-28 at 12.23.59 PM.jpg
    Screen Shot 2020-06-28 at 12.23.59 PM.jpg
    98.3 KB · Views: 4
Upvote 0
So I manually wrote down both answers and for V2 and AH2, I was looking for the correct formulas.... Thanks!
 
Upvote 0
@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.
 
Upvote 0
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!
 
Upvote 0

Forum statistics

Threads
1,213,536
Messages
6,114,215
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top