Exceljet

Quick, clean, and to the point

Increase by percentage

Excel formula: Increase by percentage
Generic formula 
=number*(1+percent)
Explanation 

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

How this formula works

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 + .2)
=70 * (1.2)
=84

Note: you must add 1 to the percent if you want to increase a number. If you don't, you'll get the amount of the number the percentage represents.

All-in-one solution

If you want an all-in-one solution, you can use a formula like this to increase a value by 5%:

=A1*105%

Just change the percentage value to suit your needs.

Author 
Dave Bruns

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.