• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

excel formula to determine the stock price term as High, low or no change

T

thakur

Member
Hi,

Need help to calculate the stock prices of the companies based on their current and initial prices.

a. In the Price Change column - calculate the exact price change of each company in $.
b. In the Net Change column:
Use an excel formula to determine if a company has seen an increase in their stock price term it as "HIGH" - if the stock price has decreased term it as "LOW" and if there has been no increase or decrease in the stock prices term it as "NO CHANGE"

Regards,
Thakur
 

Attachments

Thakur

F10: =E10-D10
G10: =IF(ABS(F10)>=15,"High",IF(ABS(F10)>5,"Med","No Change"))
Copy both down

Although for the last part you need to define how much change is classified as High/Med etc. I have assumed <$5 is No Change & >$15 is High Change
 
You must log in or register to reply here.
Back
Top