lpoincredible.blogg.se

Excel formula for subtracting a percentage
Excel formula for subtracting a percentage











excel formula for subtracting a percentage

We reduced 100% by 15% to get 85% of the total price. It was $8000 and after a discount of 15% its new value was $6800. The explanation of the mathematics in this example is that the car was originally more expensive before the discount. Therefore, the original price of the car before the discount was $8000. We divide the new amount by the decimal multiplier. we found that the decimal multiplier was 0.85. The new amount is is the current price of the car, which is $6800. Divide the new amount by this decimal multiplier We now divide this percentage by 100 to write it as a ‘decimal multiplier’. Write the percentage change as a decimal multiplierĪ discount is a percentage decrease therefore we subtract 15% from 100%. So the original price we are calculating will be higher than $6800. In this example, the new price of a car was 15% less than its original price. Therefore the original price of the television = $990 ÷ 0.90 = $1100.Įxample of finding an original amount after a percentage decrease:Ī car is sold at a 15% discount for $6800. The original cost of the television is equal to the sale price of the television divided by the decimal multiplier. What did it cost before the sale?ġ00% – 10% = 90% so following the 10% discount, the television is at 90% of its original price. The sale price of the television is $990. To find an original number after a percentage change, divide the new number by the decimal multiplier The trick for finding reverse percentagesįor example: A television is on sale with a 10% discount. Divide this new percentage by 100 to make the decimal multiplier.If the percentage change is an increase, add it to 100% or if the percentage change is a decrease, subtract it from 100%.Divide the new amount by the decimal multiplier.Write the percentage change as a decimal multiplier.The method and process described on this page explains how to reverse a given percentage increase or decrease to find an original amount. Reverse percentages are commonly used to find the original price of an item after a percentage change (discount or tax). The process of calculating an original amount following a percentage change is known as finding a reverse percentage.

excel formula for subtracting a percentage

All percentage changes can be reversed to find an original amount.













Excel formula for subtracting a percentage