Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Spreadsheets (https://www.askmehelpdesk.com/forumdisplay.php?f=395)
-   -   Discounted Rate : Errors in Spreadsheet/ Incorrect Outcome Data (https://www.askmehelpdesk.com/showthread.php?t=426534)

  • Dec 19, 2009, 05:38 PM
    MarkOliverTheBhoy
    Discounted Rate : Errors in Spreadsheet/ Incorrect Outcome Data
    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:
  • Dec 19, 2009, 05:56 PM
    ScottGem

    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.
  • Dec 19, 2009, 07:15 PM
    JBeaucaire
    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%

  • Dec 20, 2009, 02:27 AM
    MarkOliverTheBhoy

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

    Cheers
  • Dec 20, 2009, 02:56 AM
    MarkOliverTheBhoy

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

    I am getting DIV0
  • Dec 20, 2009, 03:59 PM
    JBeaucaire

    Try this:

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

  • All times are GMT -7. The time now is 10:52 PM.