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:

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.

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


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?

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

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

Cheers

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

I am getting DIV0

Try this:

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