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

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...

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...

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...

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...

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...

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 ) /...

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...

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...

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"...

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...

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...

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.