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 .
