Thanks:  0
Likes:  0

1. 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. 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. 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. 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. 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 %

User Tag List

Posting Permissions

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