What is the price of each cell phone after the discount? The result is $140.99 * 1.2 = $169.19 Subtract Percentage in Excel The result is 1 + 20% = 1.2, then multiplied by the price of a cellphone.
That is why it must be added with 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. Why should the discount percentage add to the number 1? The Formula =number*(1+percentage_increase) You can use the multiplication and addition formula to get prices after a percentage increase. What is the price of each cell phone after the price increase?
