Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Negative Percentages

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    21
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I'm trying to make a spreadsheet that shows the percentage up or down that the price of a stock is. I want the down values to be Negative but I not sure how to do that can anyone help?
    Thanks

  2. #2
    Board Regular
    Join Date
    Apr 2002
    Location
    St. Louis
    Posts
    71
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    If I understand your problem, you have a stock that was for example $100 and is now $90 and you want the formula to return -10%?

    Let me know if that is the case and I'll supply you with a formula.

    Dexter

  3. #3
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    83,656
    Post Thanks / Like
    Mentioned
    33 Post(s)
    Tagged
    6 Thread(s)

    Default

    On 2002-04-10 11:14, Chowder13037 wrote:
    I'm trying to make a spreadsheet that shows the percentage up or down that the price of a stock is. I want the down values to be Negative but I not sure how to do that can anyone help?
    Thanks
    Could you post the formula that you use along with the input values?

  4. #4
    MrExcel MVP
    Join Date
    Mar 2002
    Location
    Michigan USA
    Posts
    11,454
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-10 11:14, Chowder13037 wrote:
    I'm trying to make a spreadsheet that shows the percentage up or down that the price of a stock is. I want the down values to be Negative but I not sure how to do that can anyone help?
    Thanks
    If your Purchase price is in cell A20 $100, your current price is in cell B20 $90,then use

    =(B20-A20)/A20
    Format it as % and your result will be -10%

    HTH

    _________________
    Yogi Anand
    Edit: Deleted inactive web site reference from hard code signature line

    [ This Message was edited by: Yogi Anand on 2003-01-19 17:36 ]

  5. #5
    Board Regular
    Join Date
    Apr 2002
    Posts
    113
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-10 11:28, Yogi Anand wrote:
    On 2002-04-10 11:14, Chowder13037 wrote:
    I'm trying to make a spreadsheet that shows the percentage up or down that the price of a stock is. I want the down values to be Negative but I not sure how to do that can anyone help?
    Thanks
    If your Purchase price is in cell A20 $100, your current price is in cell B20 $90,then use

    =(B20-A20)/A20
    Format it as % and your result will be -10%

    HTH

    _________________
    Yogi Anand
    ANAND Enterprises
    http://www.handtech.com/anand yogia@hotmail.com

    [ This Message was edited by: Yogi Anand on 2002-04-10 11:29 ]
    =(A2-A1)/A2
    cell format set to %

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •