Negative Percentages

[Chowder13037]

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

[Dexter]

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

[Aladin Akyurek]

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?

[Yogi Anand]

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 ]

[kmiles]

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 %