How to Use Percent Discount in Excel

Written by mark kennan
  • 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

Other People Are Reading

Things you need

  • Computer
  • Microsoft Excel

Show MoreHide

Instructions

  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

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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