Now that we have the discount amount and the Original price we can just feed the. In the example the active cell contains this formula. In Column D the calculation is the original price in column B2 minus the sale reduction in C2.
Convert this decimal amount into a percentage.
Is 200 25100. Enter a decimal number 02 in cell B1 and apply a Percentage format. Now that we have the discount amount and the Original price we can just feed the. Discounted_price original_price - original_price discount 100.