Making Consecutive Discounts

An Excel file that teaches how to perform Making Consecutive Discounts operation.

Excel Template for Making Consecutive Discounts

The remaining amount after the first discount is used as the basis for the new discount. The formula is adjusted according to the percentage rate. Sequential discounts are calculated using the multiplier logic. The final price is automatically reflected in the table. The summary field shows the final total.

Hope it is useful.