How to Calculate Final Price After Discount in Excel (Formula & Examples)

Learn how to calculate the final price after a discount in Excel using simple formulas. Includes percentage discounts, practical examples, and step-by

 

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.

   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:

  • A2 contains the original price.

  • B2 contains the discount percentage.

  • 1 represents 100% of the original price.

  • 1-B2 calculates 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-B2

Where:

  • A2 contains the original price.

  • B2 contains 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

=A2*(1-B2)

Discount amount

=A2*B2

Final price after fixed discount

=A2-B2

Final price after two discounts

=A2*(1-B2)*(1-C2)

Final price after three discounts

=A2*(1-B2)*(1-C2)*(1-D2)

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:

  1. Select the cells containing the final prices.

  2. Go to the Home tab.

  3. Find the Number section.

  4. Click the Currency or Accounting Number Format option.

  5. 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-B2 is 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

Loaded All Posts Not found any posts VIEW ALL Readmore Reply Cancel reply Delete By Home PAGES POSTS View All RECOMMENDED FOR YOU LABEL ARCHIVE SEARCH ALL POSTS Not found any post match with your request Back Home Sunday Monday Tuesday Wednesday Thursday Friday Saturday Sun Mon Tue Wed Thu Fri Sat January February March April May June July August September October November December Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec just now 1 minute ago $$1$$ minutes ago 1 hour ago $$1$$ hours ago Yesterday $$1$$ days ago $$1$$ weeks ago more than 5 weeks ago Followers Follow THIS PREMIUM CONTENT IS LOCKED STEP 1: Share to a social network STEP 2: Click the link on your social network Copy All Code Select All Code All codes were copied to your clipboard Can not copy the codes / texts, please press [CTRL]+[C] (or CMD+C with Mac) to copy Table of Content