The result is 0.8, which is then multiplied by the price of the cellphone in cell B2, $140.99*0.8. Cell C2 contains the number 20% equal to the 0.2 value. Number 1 is subtracted by the percentage discount. For instance, you want to subtract 1 from 10, you can write the equation 10-1 and. The Formula =number*(1-percentage_decrease)įirst, Excel will calculate the formula (1-C2). However, you can use the basic subtraction formula which is a minus sign (-). 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. If you directly multiply the price and the discount, then you got the discount value, not the price after discount. The given percentage is the discount percentage. 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? On this solution, the formula on K14 becomes ROUNDUP (J14/J15,2) The '2' means two decimals - which is zero decimals in percentage notation. This way, it will work for any two input numbers. The Formula =number*(1+percentage_increase) WHAT IS SUBTRACTING PERCENTAGE IN EXCEL 1.SUBTRACTING ONE PERCENTAGE FROM THE OTHER SUBTRACTING THE PERCENTAGE WHEN THE SPAN OR TOTAL VALUE OR DENOMINATOR ARE SAME WHEN THE TOTAL VALUE OR DENOMINATOR ARE DIFFERENT FOR THE TWO PERCENTAGE 2. You can roundup your number as a formula. 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?

Excel formula subtract percentage