Ask Experts Questions for FREE Help !
Ask
    MarkOliverTheBhoy's Avatar
    MarkOliverTheBhoy Posts: 3, Reputation: 1
    New Member
     
    #1

    Dec 19, 2009, 05:38 PM
    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:
    ScottGem's Avatar
    ScottGem Posts: 64,966, Reputation: 6056
    Computer Expert and Renaissance Man
     
    #2

    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's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #3

    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's Avatar
    MarkOliverTheBhoy Posts: 3, Reputation: 1
    New Member
     
    #4

    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's Avatar
    MarkOliverTheBhoy Posts: 3, Reputation: 1
    New Member
     
    #5

    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's Avatar
    JBeaucaire Posts: 5,426, Reputation: 997
    Software Expert
     
    #6

    Dec 20, 2009, 03:59 PM

    Try this:

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

Not your question? Ask your question View similar questions

 

Question Tools Search this Question
Search this Question:

Advanced Search

Add your answer here.


Check out some similar questions!

Collect data into 2 combo boxes from data in an access table [ 1 Answers ]

I have two combo boxes. When the form loads the db connection opens a recordset that selects all the data from the retaillocations table. When you choose the region (0-4), that number loads into a text box and the Contacts load into the forst combo box. Now I want to select only the Name based on...

Figuring out interest rate on discounted bonds [ 2 Answers ]

here is the problem Exercise 10-2 Straight-line amortization of bond discount L.O. P2 Sears issues bonds with a par value of $175,000 on January 1, 2009. The bonds' annual contract rate is 4%, and interest is paid semiannually on June 30 and December 31. The bonds mature in three years. The...

Transmitting data and receiving data wireless through moirco-controller [ 2 Answers ]

Hi I want to transmit data from one microcontroller to another microcontroller wirelessly. The micro-controller are connected to one computer each through a serial cable. I want it to transmit data from the hyper terminal to the 1st micro-controller. For example, when I type the letter "a", it...

Retrive data from another spreadsheet [ 15 Answers ]

Hello I have a macro that retrives data into a template. But I need to have the macro retrieve from the other file no matter what the name is. Ok lets say I have opened spreadsheet named 10971. The macro opens the blank template file and populates correctly. This works good. But I want to have...


View more questions Search