Negative Percentages

Chowder13037

New Member
Joined
Apr 9, 2002
Messages
21
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
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
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
 
Upvote 0
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?
 
Upvote 0
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
 
Upvote 0
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 %
 
Upvote 0

Forum statistics

Threads
1,213,528
Messages
6,114,154
Members
448,553
Latest member
slaytonpa

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top