Calculate Discount in Excel

Learn how to easily find out the discount percentage of any product using this simple Excel formula. Calculate the final value by applying the discount!

One of the most useful formulas to use in spreadsheets is for discount percentages. With this formula you can easily find out the final value by applying any amount of discount to any price.

Formula to find out the discount value

There are several ways of discovering a discount percentage for any value but the most simple is:

discounted value = (discount percentage * total value) / 100

For example, if you would like to know the discounted value of something that costs €3,000 and has a discount of 15%:

(15 * 3000) / 100 = 450

To understand the formula in terms of cells, where the percentage is placed in cell A1 and the price in cell A2:

(A1 * A2) / 100

Finally, if you want to know the final cost of a product, simply subtract the amount of the discount from the initial amount:

final value (with discount applied) = initial value - ((discount percentage * total value)/100)

Other forms of calculating discount in Excel

If you prefer, here you will find other formulas for calculating percentages using Excel or any other type of spreadsheet.

View all Excel Functions.