# 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

### Things you need

• Computer
• Microsoft Excel

## 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

#### References

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