Stacked Multiple Discount Calculator

Need to calculate a stacked percentage discount on an amount? Is it a double, triple, or multi-step discount?
For example, do you need to calculate a discount of 50 + 20 + 10? Or more generally X% + Y% + Z%?💲✂️
Well, just use the discount calculation tool below! 👇

Enter up to 6 percentage discounts:

Enter the amount, set discounts and click "Calculate Discounted Amount"

How to use this multiple discount tool

Using the tool on this page is simple:

The double, triple, or multi-step discount calculation criterion

Let's simulate the calculation of a multiple discount, step by step.

Suppose the initial amount is X to which a successive / progressive discount of 50+30+20 is to be applied.

  1. Apply the first discount (50%) to the initial amount. We will thus have the amount after the first discount:
    Amount after first discount = X * 0.5
  2. Apply the second discount (30%) to the amount obtained previously:
    Amount after second discount = Amount after first discount - (Amount after first discount * 0.3)
  3. As before, apply the third discount (20%) to the amount obtained in step 2:
    Final amount = Amount after second discount - (Amount after second discount * 0.2)
See an example

Suppose the initial amount is 100.

  1. Apply the first discount (50%):
    Amount after first discount = 100 * 0.5 = 50
  2. Apply the second discount (30%):
    Amount after second discount = 50 - (50 * 0.3) = 50 - 15 = 35
  3. Apply the third discount (20%):
    Final amount = 35 - (35 * 0.2) = 35 - 7 = 28

Therefore, the final amount after applying consecutive discounts of 50%, 30%, and 20% is 28.

The multiple discount formula

OK, now let's see and explain the formula for calculating multiple discounts.

Formula with Two Discounts

The first formula calculates the new price after applying two discounts, denoted as x and y. The formula is presented as follows:

Double Discount Formula
The Double Discount Formula

New Price = Initial Price × (1 - x) × (1 - y)

Formula with Multiple Discounts (Triple, Quadruple and more)

The second formula extends the first by including an additional discount and the possibility of further unspecified discounts between the second and the last. This is represented with the variable z and ellipsis for potential additional discounts. The formula is:

New Price = Initial Price × (1 - x) × (1 - y) × ... × (1 - z)

These formulas are useful for calculating the final price of an item after applying several stacked discounts, which is common in sales promotions.

Multiple Discount Formula
The Multiple Discount Formula

Excel sheet for calculating multiple discounts

Are you looking for an Excel spreadsheet that allows you to calculate multiple discounts conveniently in one place?

I have what you're looking for - you'll just need to download this file and fill in the columns you need for the calculation:

Download XLSX Multiple Discount sheet
Microsoft Excel icon donwload
Download Libre Office Multiple Discount sheet
Microsoft Excel icon donwload