# 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 result60. 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% ) * 50Read more : How to take a screenshot on LG smartphones

– 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

PricePrice After

15% Discount2 $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

PricePrice After

15% Discount2 $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 .