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 More

## Instructions

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

#### Tips and warnings

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