Here are the steps to follow in this lesson:
- To calculate the % of discount received: =”Savings”/”Original Price.”
- Excel follows an “Order of Precedence” when performing calculations: It performs multiplication and division before performing operations involving addition and subtraction.
- Enclose portions of your formula inside () in order to control the order of your calculations.
- 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.
Link to this post!