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 .
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
Read more : How to take a screenshot on LG smartphones
– which give the consequence 40. This be prove in the follow spreadsheet .
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 .
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 :
A B 1 Original
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
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 .
class : Tutorial