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