Check out some similar questions!

MarkOliverTheBhoy · Dec 19, 2009, 05:38 PM

Hi Guys.

This is my first time here at Askme and I am hoping that you will be able to help.

I am currently trying to make a spreadsheet where I will be able to calculate discounted rate(in a percentage)

This is what I am looking to achieve -

Unit Price Sold Price Discount %
250 100 40%

=(Sold Price/Unit Price)*100

However I keep getting incorrect figures when I have figures more than 3 figures

Unit Price Sold Price Discount %
1500 200 13.3%

Obviousy my discount is not 13%

And Finally - when I input the following example

Unit Price Sold Price Discount %
250 250 100%

Is there anyway that I can sound proof this formulae which will take into consideration what I am trying to achieve?

Thank you in advance for any help

A rather tired

mark:confused:

ScottGem · Dec 19, 2009, 05:56 PM

Actually the numbers are correct. 200 is 13.3% of 1500. So what are you actually tryig to calculate? If you sold something for 200 and its supposed to cost 1500, then you sold it for 13.3% of cost.

JBeaucaire · Dec 19, 2009, 07:15 PM

What you've shown here is how much the sold price is OUT of the unit price. 100 is 40% of 250.

Code:

Unit Price     Sold Price       Discount %
250             100               40%
1500            200               13.3%

I think this is what you're after... a listing showing you how much of a discount the person received... yes?

Code:

    A               B              C
Unit Price	Sale Price	Discount	
   250	           100	         60.0%	   =1-(B2/A2)
  1500	           200	         86.7%	
   250	           250	          0.0%

MarkOliverTheBhoy · Dec 20, 2009, 02:27 AM

This is correct thank you for such a fast reply - I was starting to get rather annoyed.

Cheers

MarkOliverTheBhoy · Dec 20, 2009, 02:56 AM

One other point - how do I get it not to show if no information has been inputed?

I am getting DIV0

JBeaucaire · Dec 20, 2009, 03:59 PM

Try this:

=IF(COUNT(A2:B2)=2, 1-(B2/A2), "")