Excel formula: Get percentage discount

Generic formula

= 1-(discount_price/original_price)

Summary

If you have a discounted price and an original price, and you want to know the discount as a percentage, you can calculate the percentage discount using a formula that divides the discounted price by the original price and then subtracts the result from one.

Explanation

In the example, the active cell contains this formula:

=1-(D5/C5)

In this case, Excel first divides the discounted price in D5 (59.5) by the original price in C5 (70) to get 0.85, which is then subtracted from 1:

=1-(59.5/70)
=1-0.85
=0.15

Note: the result is a decimal value, and must be formatted using the Percentage number format in Excel to display as a percentage.

Author

Dave Bruns

Related formulas

Get total from percentage

In the example, the active cell contains this formula: =C6/D6 Excel simply divides the value in cell C6 by the percentage value in cell D6. The result is the number $1,120, which is the total of all expenses in this case. Note that the value in cell...

Increase by percentage

In the example, the active cell contains this formula: = C6 * ( 1 + D6 ) In this case, Excel first calculates the result of 1 + the value in D6 (.2) to get 1.2 which it then multiplies times the value in C6 (70) to get a final result of 84: =70 * (1...

Decrease by percentage

In the example, the active cell contains this formula: = C6 * ( 1 - D6 ) In this case, Excel first calculates the result of 1 - the value in D6 (.2) to get 0.8 which it then multiplies times the value in C6 (70) to get a final result of 56: =70 * (1...

Get original price from percentage discount

In the example, the active cell contains this formula: = C6 / ( 1 - D6 ) In this case, Excel first calculates the result of 1 - the value in D6 (.2) to get 0.8. Next the value in C6 (56), which represents the discounted or "sale" price, is divided...

Cap percentage at specific amount

This formula uses the MIN function to make a decision that might otherwise be handled with the IF function . Although MIN is usually used to return the minimum value in a data set with many numbers, it also works fine for "lesser of the two"...

Get profit margin percentage

If you need to calculate a profit margin, you can easily do so with a simple formula that uses the sale price and the cost. In the example shown, the first formula looks like this: = ( B4 - C4 ) / B4 Make sure you use parentheses to control the...

Excel Formula Training

Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.