Here are the steps to follow for this lesson:

1. To reveal the formula in a single cell, double-click the cell or press the F2 key.
2. To reveal all of the formulas in the worksheet use Ctrl + Tilde (Ctrl+˜) – This is a “toggle.”
3. There are 4 ways to write a formula to show the discounted price:
   1. If the cell containing the discount % is a negative (-20%) number =B5+(B5*$D$2)
   2. If the cell containing the discount % is a positive (20%) number =B5-(B5*$G$2)
   3. If the cell containing the discount % is a negative (-20%) number =B5*(1+$D$2)
   4. If the cell containing the discount % is a positive (20%) number =B5*(1-$G$2)

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.

Related Videos

• Trust your sources but verify the accuracy of your data