# How to Calculate a Percentage Increase in Excel

home » Excel-Formulas » Percentage-Increase

# How to Calculate Percentage Increase in Excel

related page :Calculate Percentage Change

## How To Increase a Number By a Percentage

If desire to calculate vitamin a percentage increase in excel ( i.e. increase a number aside vitamin a specify percentage ), this toilet be do aside merely multiply the number aside one + the share increase.

For exemplar, if you want to increase the total fifty by twenty %, this can be done indiana excel by type the follow formula into any excel cell : =( 1 + 20% ) * 50 – which give the result 60. note that, in the above formula :

• The % operator tells Excel to divide the preceding number by 100. Therefore, the value 20% in the above calculation is evaluated as 0.2;
• The brackets are essential in the calculation.

a with any excel rule, the share increase calculation buttocks use value that be store in your spreadspeed, rather of actual number. This be usher below .

convention :

A B
1 Original Value: 50
2 Original Value Increased by 20%: =(1 + 20%) * B1
leave :

A B
1 Original Value: 50
2 Original Value Increased by 20%: 60

## How To Decrease a Number By a Percentage

If lack to decrease ampere act aside vitamin a specific percentage, plainly breed the number by one subtraction the percentage decrease. For case, if you want to decrease the act fifty by twenty %, this can be dress inch excel by type the follow recipe into any excel cell : =( 1 – 20% ) * 50

– which give the consequence 40. This be prove in the follow spreadsheet .

rule :

A B
1 Original Value: 50
2 Original Value decreased by 20%: =(1 – 20%) * B1
consequence :

A B
1 Original Value: 50
2 Original Value decreased by 20%: 40

## Further Percentage Increase/Decrease Examples

### Example 1 – Sales Tax Calculation

cell B2 of the following spreadsheet appearance the addition of gross sales tax at 22.5 %, to associate in nursing bill entire .

formula :

A B
1 Invoice Total (before tax): 1240
2 Invoice Total (after 22.5% sales tax): =(1 + 22.5%) * B1
result :

A B
1 Invoice Total (before tax): 1240
2 Invoice Total (after 22.5% sales tax): 1519

### Example 2 – Applying a Discount

a denounce have a sale, in which commodity are offer astatine ampere fifteen % rebate to their original price. The calculation of the new price of several item, after the discount be enforce, be show in column bacillus of the follow spreadsheet :

recipe :

A B
1 Original
Price
Price After
15% Discount
2 \$75.00 =(1 – 15%) * A2
3 \$100.00 =(1 – 15%) * A3
4 \$125.00 =(1 – 15%) * A4
5 \$150.00 =(1 – 15%) * A5
resultant role :

A B
1 Original
Price
Price After
15% Discount
2 \$75.00 \$63.75
3 \$100.00 \$85.00
4 \$125.00 \$106.25
5 \$150.00 \$127.50

For far case of calculating percentage increase oregon decrease in excel, see the Microsoft office web site .

operating room, for associate in nursing overview of different type of percentage calculation, learn the share in excel page .