Announcement

Collapse
No announcement yet.

Unconfigured Ad Widget

Collapse

Figuring list price - cost to show discount percentage

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Figuring list price - cost to show discount percentage

    Ok, I'm mathmatically challenged, but I love Excel an figure this should be pretty easy. Here is my problem.

    List Price $46.98 (e2)
    Net Cost $19.53 (e3)

    How do I enter a calculation that will show me my discount percentage from my supplier? (e4)

    I then need to be able to drag the formula to the end of the sheet. Discount percentages will be different for each product, but the List Price and Net Costs are present, so the calculation needs to take these differences into consideration so that I get the correct discount percentage for each item. Thank you!

    Theresa

  • #2
    Re: Figuring list price - cost to show discount percentage

    Originally posted by Sindril
    Ok, I'm mathmatically challenged, but I love Excel an figure this should be pretty easy. Here is my problem.

    List Price $46.98 (e2)
    Net Cost $19.53 (e3)

    How do I enter a calculation that will show me my discount percentage from my supplier? (e4)

    I then need to be able to drag the formula to the end of the sheet. Discount percentages will be different for each product, but the List Price and Net Costs are present, so the calculation needs to take these differences into consideration so that I get the correct discount percentage for each item. Thank you!

    Theresa
    Formula for cell E4 should be =ROUND(100*(E2-E3)/E2,2)
    .

    Comment


    • #3
      Re: Figuring list price - cost to show discount percentage

      I appreciate your help so very much and have a question. When I use your formula I get 57.13%. When I use the calculator I get 58.4%. Any idea why the large disparity?

      Sindril

      Comment


      • #4
        Re: Figuring list price - cost to show discount percentage

        Well, could you re-check what you posted was what you have in your sheet? I get 58.43, formula and calculator.
        .

        Comment


        • #5
          Re: Figuring list price - cost to show discount percentage

          Yeppers, I should have said F2 NOT E3:

          =ROUND(100*(E2-F2)/E2,2)

          Now it works just dandy! Except that it shows 5843.00. Can I ask one final question? How do I get it to put the decimal in the correct place, which in this case would make it 58.43? Again, thank you!

          Sindril

          Comment


          • #6
            Re: Figuring list price - cost to show discount percentage

            I would say impossible, but what do you have in E2, F2?
            Regards,

            Wigi

            Excel MVP 2011-2014

            For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

            -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

            Comment


            • #7
              Re: Figuring list price - cost to show discount percentage

              What have you got in F2 then? The problem with percentages is that it depends how you have the cell formatted. Really, the answer should be 58.43%, which means formatting cell E4 as a percentage, with 2 decimal places (go to Format, Cell, Number) and then the actual value of the cell should be 0.58. Test it by putting "=1*E4" in another cell. Depending on the format, you might need to remove the "100*" from the formula.
              Last edited by ByTheCringe2; April 25th, 2006, 05:31.
              .

              Comment


              • #8
                Re: Figuring list price - cost to show discount percentage

                E2 = $46.98
                F2= $19.53
                G2= 5843.00%

                Comment


                • #9
                  Re: Figuring list price - cost to show discount percentage

                  Theresa,

                  if G2 is formatted as a percentage, then remove the part *100
                  Regards,

                  Wigi

                  Excel MVP 2011-2014

                  For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

                  -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

                  Comment


                  • #10
                    Re: Figuring list price - cost to show discount percentage

                    Okay, you are right. Once I changed the cell to number instead of % is shows me 58.43 which is exactly what I needed to see. I know it is a percentage and that's all that counts in my particular application.

                    Have an awesome day!
                    Sindril

                    Comment


                    • #11
                      Re: Figuring list price - cost to show discount percentage

                      Glad you're sorted. Have a nice day too Theresa.
                      Regards,

                      Wigi

                      Excel MVP 2011-2014

                      For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

                      -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

                      Comment

                      Trending

                      Collapse

                      There are no results that meet this criteria.

                      Working...
                      X