Add Percentage in Excel
What is the price of each cell phone after the price increase?
You can use the multiplication and addition formula to get prices after a percentage increase.
The Formula
=number*(1+percentage_increase)
How does the formula work?
=B2*(1+C2)
The first calculated formula is (1+C2). Why should the discount percentage add to the number 1?
If the percentage of the discount is directly multiplied by the price, then you got the increased value, not the price after the increase. That is why it must be added with number 1.
The result is 1 + 20% = 1.2, then multiplied by the price of a cellphone.
The result is $140.99 * 1.2 = $169.19
Subtract Percentage in Excel
What is the price of each cell phone after the discount?
The given percentage is the discount percentage. If you directly multiply the price and the discount, then you got the discount value, not the price after discount.
To find out the price after the discount, the discount percentage must be deducted by number 1; the new result is multiplied by the price to get the price after the discount.
The Formula
=number*(1-percentage_decrease)
How does the formula work?
=B2*(1-C2)
First, Excel will calculate the formula (1-C2). Number 1 is subtracted by the percentage discount. Cell C2 contains the number 20% equal to the 0.2 value.
The result is 0.8, which is then multiplied by the price of the cellphone in cell B2, $140.99*0.8. The result is $112.79.
How to get the original number after adding/subtracting percentages in excel? Read the following article:
