How to Use Percent Discount in Excel

Written by michael keenan
  • Share
  • Tweet
  • Share
  • Email

Microsoft Excel is a spreadsheet program that can be very useful for rapidly entering and calculating percentage discounts. You can quickly and easily set up a spreadsheet where you can enter an item's original price and the per cent discount, and Microsoft Excel will automatically calculate the final price.

Skill level:
Moderately Easy

Things you need

  • Computer
  • Microsoft Excel

Show MoreHide


  1. 1

    Enter "Original Price" in cell A1, "Percent Discount" in cell A2 and "Discounted Price" in cell A3.

  2. 2

    Enter the original price of the item in cell B1. For example, if the item was £32, you would enter "50."

  3. 3

    Enter the percentage discount as a decimal in cell B2. For example, if the discount was 35 per cent, you would enter 0.35.

  4. 4

    Enter "=B1*(1-B2)" in cell B3 to calculate the final price of the item.

Tips and warnings

  • Make sure you enter the percentage as a decimal or your final price will be off.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.