We Value Your Privacy

We and our partners use technology such as cookies on our site to personalise content and ads, provide social media features, and analyse our traffic. Click below to consent to the use of this technology across the web. You can change your mind and change your consent choices at anytime by returning to this site.

Update Consent
Loading ...

How to Use Percent Discount in Excel

Updated September 03, 2018

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.

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

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

  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. Enter "=B1*(1-B2)" in cell B3 to calculate the final price of the item.

  5. Warning

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

Loading ...

Things You'll Need

  • Computer
  • Microsoft Excel

About the Author

Mark Kennan is a writer based in the Kansas City area, specializing in personal finance and business topics. He has been writing since 2009 and has been published by "Quicken," "TurboTax," and "The Motley Fool."

Loading ...