Learn how to calculate the final price after a discount in Excel with easy formulas and practical examples. Discover how to apply percentage discounts, fixed discounts, and multiple discounts to calculate accurate product prices.
How to Calculate Final Price After Discount in Excel
Calculating the final price after applying a discount is a common task in shopping, retail, sales, and business management. Whether you are preparing a sales report, calculating product prices, or checking how much a customer needs to pay, Microsoft Excel can handle these calculations quickly.
Instead of calculating every discounted price manually, you can use a simple Excel formula to get accurate results in seconds.
For example, suppose a product costs $500 and a store offers a 20% discount. The customer does not need to pay the full $500. After applying the discount, the final price becomes $400.
In this guide, you will learn how to calculate the final price after a discount in Excel using simple formulas, practical examples, and an easy-to-follow table.
Understanding the Final Price After a Discount
Before using Excel formulas, it is helpful to understand how a discount affects the original price.
The final price is the amount a customer pays after subtracting the discount from the original selling price.
The basic calculation involves two steps:
Calculate the discount amount.
Subtract the discount amount from the original price.
Basic Formula:
Final Price = Original Price − Discount Amount
For example:
Original Price: $1,000
Discount: 15%
Discount Amount: $150
Final Price: $850
Excel can perform both calculations automatically using a single formula.
Excel Formula to Calculate Final Price After Discount
The easiest way to calculate a discounted price in Excel is to multiply the original price by 1 minus the discount percentage.
Formula:
=A2*(1-B2)Here is what each cell represents:
A2contains the original price.B2contains the discount percentage.1represents 100% of the original price.1-B2calculates the remaining percentage after the discount.
For example, if cell A2 contains $1,000 and B2 contains 15%, Excel calculates:
=1000*(1-15%)Result: $850
This formula is useful when you need to calculate discounted prices for multiple products.
Step-by-Step Example: Calculate Discounted Price in Excel
Let's understand the calculation with a practical example.
Imagine you run an online store and want to calculate the final prices of five products after applying different discounts.
Enter the following information into an Excel worksheet:
Product | Original Price | Discount |
|---|---|---|
Laptop | $1,000 | 10% |
Smartphone | $800 | 15% |
Headphones | $200 | 20% |
Keyboard | $100 | 5% |
Monitor | $500 | 25% |
Now, follow these steps:
Step 1: Enter the Product Information
Open Microsoft Excel and enter the product names, original prices, and discount percentages in columns A, B, and C.
Step 2: Select the Final Price Cell
Click cell D2, where you want the discounted price of the first product to appear.
Step 3: Enter the Formula
Type the following formula:
=B2*(1-C2)Step 4: Press Enter
Press Enter, and Excel will calculate the final price after applying the discount.
Step 5: Apply the Formula to Other Products
Select cell D2 and drag the fill handle (the small square at the bottom-right corner of the cell) down to the remaining rows.
Excel will automatically adjust the cell references and calculate the discounted price for every product.
Your worksheet will now look like this:
Product | Original Price | Discount | Final Price |
|---|---|---|---|
Laptop | $1,000 | 10% | $900 |
Smartphone | $800 | 15% | $680 |
Headphones | $200 | 20% | $160 |
Keyboard | $100 | 5% | $95 |
Monitor | $500 | 25% | $375 |
You can now calculate discounted prices for multiple products without repeating the calculations manually.
Calculate Final Price Using the Discount Amount
Sometimes, you may already know the discount amount instead of the discount percentage.
For example, a product costs $750, and the store offers a direct discount of $100.
In this situation, you can use a simple subtraction formula.
Excel Formula:
=A2-B2Where:
A2contains the original price.B2contains the discount amount.
Example:
Original Price | Discount Amount | Final Price |
|---|---|---|
$750 | $100 | $650 |
$1,200 | $200 | $1,000 |
$500 | $75 | $425 |
$900 | $150 | $750 |
This method is particularly useful when a store offers a fixed discount rather than a percentage-based discount.
Calculate Final Price With a Discount Percentage in a Single Formula
If you don't want to calculate the discount amount separately, Excel can calculate the final price directly.
For example, suppose:
Original Price = $2,500
Discount = 12%
Enter this formula:
=2500*(1-12%)Result: $2,200
You can also use cell references:
=A2*(1-B2)This approach is convenient for invoices, product lists, retail pricing, and sales reports.
Calculate Final Price After Multiple Discounts
Some businesses offer more than one discount on a product. For example, a store may offer a 10% seasonal discount followed by an additional 5% discount.
In this situation, the second discount is generally applied to the already discounted price, not the original price.
Suppose a product costs $1,000.
Original Price: $1,000
First Discount: 10%
Second Discount: 5%
Excel Formula:
=A2*(1-B2)*(1-C2)Calculation:
After the first 10% discount: $900
After the additional 5% discount: $855
Final Price: $855
This formula is helpful when calculating promotional offers with multiple successive discounts.
Common Excel Discount Calculation Formulas
Here is a quick reference table covering different ways to calculate the final price after a discount.
Calculation | Excel Formula |
|---|---|
Final price after percentage discount |
|
Discount amount |
|
Final price after fixed discount |
|
Final price after two discounts |
|
Final price after three discounts |
|
Tip: If you enter a discount as 20%, Excel understands it as a percentage. If you enter 20 instead, use 20/100 in the formula or divide the discount by 100.
Format the Final Price as Currency in Excel
Once you calculate the discounted prices, you may want to display them in a professional currency format.
Follow these steps:
Select the cells containing the final prices.
Go to the Home tab.
Find the Number section.
Click the Currency or Accounting Number Format option.
Select your preferred currency symbol, such as $, €, £, or ₹.
Excel will display your calculated prices in the selected currency format.
For example, a value of 850 can appear as $850.00 or ₹850.00, depending on your settings.
Common Mistakes to Avoid When Calculating Discounts in Excel
Even a simple discount calculation can produce incorrect results if the data is entered incorrectly.
Here are a few common mistakes to watch out for:
Entering the wrong percentage: If you enter 20 instead of 20%, Excel may calculate an incorrect result.
Using the wrong cell references: Make sure the formula refers to the original price and the correct discount cell.
Subtracting the percentage directly: A formula such as
=A2-B2is incorrect when B2 contains a discount percentage rather than a discount amount.Applying multiple discounts incorrectly: Successive discounts are normally calculated on the remaining price, not by simply adding the discount percentages.
Ignoring currency formatting: Apply the appropriate currency format to make your worksheet easier to read.
Checking these details will help you avoid errors in product pricing, invoices, and business reports.
Frequently Asked Questions (FAQs)
Q1. What is the Excel formula for calculating the final price after a discount?
Use =A2*(1-B2), where A2 contains the original price and B2 contains the discount percentage.
Q2. How do I calculate a 20% discount in Excel?
Enter =A2*(1-20%) to calculate the final price after a 20% discount.
Q3. How do I calculate the discount amount separately?
Use =A2*B2, where A2 is the original price and B2 is the discount percentage.
Q4. Can Excel calculate discounted prices for multiple products?
Yes. Enter the formula in the first row and drag the fill handle down to apply it to other products.
Q5. Can I calculate the final price after two discounts in Excel?
Yes. Use =A2*(1-B2)*(1-C2) to apply two successive percentage discounts.
Final Thoughts
Calculating the final price after a discount in Excel is simple once you understand the correct formula. For percentage-based discounts, =A2*(1-B2) is one of the easiest and most useful methods.
You can use this formula to manage product prices, prepare invoices, calculate promotional offers, and create sales reports. Instead of spending time on manual calculations, let Excel handle the work automatically.
Practice these examples with your own product prices, and you will be able to calculate discounted prices quickly and accurately.

COMMENTS