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
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 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
Could you post the formula that you use along with the input values?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 useOn 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
=(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 ]
=(A2-A1)/A2On 2002-04-10 11:28, Yogi Anand wrote:
If your Purchase price is in cell A20 $100, your current price is in cell B20 $90,then useOn 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
=(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 ]
cell format set to %
Like this thread? Share it with others