Exceljet

Quick, clean, and to the point

Decrease by percentage

Excel formula: Decrease by percentage
Generic formula 
=number*(1-percent)
Summary 

If you need to decrease a number by a certain percentage, you can use a simple formula that multiplies the number times the percent - 1.

Explanation 

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 - .2)
=70 * (0.8)
=56

Note that must subtract the percent from 1 if you want to decrease a number. If you don't, you'll simply get the amount of the number that the percentage represents.

Author 
Dave Bruns
Related formulas 
Excel formula: Increase by percentage
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...
Excel formula: Get original price from percentage discount
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...
Excel formula: Get total from percentage
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...
Excel formula: Get percentage of total
Get percentage of total
In the example, D6 contains the formula below, copied down: = C6 / $C$11 In cell D6, the result of the calculation is .625. The Percentage number format is applied to cell D6, with 2 decimal places, so Excel displays .625 as 63%. The reference to...
Excel formula: Get percentage discount
Get percentage discount
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...
Excel formula: Get percent change
Get percent change
Following order of operations, Excel first calculates the difference between the values (the actual change in sales) then divides that result by the original, or "old" value to get the decimal value -0.3435: = ( D6 - C6 ) / C6 = ( 49500 - 75400 ) /...
Excel formula: Calculate percent variance
Calculate percent variance
The concept of variance requires a baseline value and a "new" value. Once you calculate the difference between the two numbers, you only need to divide by the original value. In the example, we are calculating a variance from forecast, so we need...
Excel formula: Get original number from percent change
Get original number from percent change
In the example, the active cell contains this formula: = C6 / ( B6 + 1 ) In this case, Excel first calculates the result of B6 + 1, then divides C6 by the result: = C6 / ( B6 + 1 ) = 200 / 1.15 = 173.913 Rounded result In the example shown, values...
Excel formula: Cap percentage at specific amount
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"...
Excel formula: Percent sold
Percent sold
This formula simply divides the told sold by the total. In cell E6, the formula is solved like this: = D6 / C6 = 120 / 144 = 0.83333 When the result is formatted using the Percentage number format .83333 is displayed as 83%. Note: when working...
Excel formula: Percent of students absent
Percent of students absent
The formula in F5 first calculates the number of students absent using (C6-D6), then divides the result by the total students. So the formula reduces like this: = ( C6 - D6 ) / C6 = ( 100 - 92 ) / 100 = 8 / 100 = .08 When formatted using the...
Related courses 
Core Formula

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.

500 Formulas | 101 Functions

Download 200+ Excel Shortcuts

Get over 200 Excel shortcuts for Windows and Mac in one handy PDF.