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
  • Yahoo! Buzz
  • Google Bookmarks
  • Orkut
  • SphereIt
  • Sphinn

Speak Your Mind