When a price inclusive the tax is mentioned in such cases reverse tax is applied. To calculate the percentage change between two numbers in Excel execute the following steps. Enter an old number in cell A1 and a new number in cell B1.
Therefore the original number can be calculate as 1004400.
Using reverse percentages is a way of working backwards on a percentages problem in order to find the original amount. Calculating reverse percentages depends on knowing that before an increase or decrease in price an item is always worth 100 of its value no matter what that value is. You want Sell Price - 30 Sell Price Cost Price. C6 D6 To calculate the amount Excel simply multiplies the value in cell C6 1120 by the percentage value in cell D6 625.