How to calculate the percentage of discount received

Here are the steps to follow in this lesson:

  1. To calculate the % of discount received: =”Savings”/”Original Price.”
  2. Excel follows an “Order of Precedence” when performing calculations: It performs multiplication and division before performing operations involving addition and subtraction.
  3. Enclose portions of your formula inside () in order to control the order of your calculations.
  4. To determine the “Original Price” when you know the “Sale Price” and the “% of Discount”: =”Sale Price”/ (1-”% of Discount”)

Find the video lesson that you want – Index to all Excel Topics

News! My DVD, “The 50 Best Tips for Excel 2007″ is now available to purchase. I invite you to visit my online bookstore for more details.

Share and Enjoy:
  • Add to favorites
  • Facebook
  • Twitter
  • Technorati
  • Print
  • email
  • Digg
  • StumbleUpon
  • del.icio.us
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

rss Subscribe to our RSS Feed

This entry was posted on Monday, July 28th, 2008 at 10:52 AM and is filed under Everyday Calculations in Excel, Excel Training, Most Viewed Excel Videos. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

«
»

One Response to “How to calculate the percentage of discount received”

  1. The Company Rocks Excels » Blog Archive » Most popular Excel Video Lessons in July 2008 Says:
    August 28th, 2008 at 1:39 AM

    [...] How to calculate the percentage of discount [...]

Leave a Reply

Powered by WishList Member - Membership Site Software