How to calculate discount in Excel
Discount is the amount deducted from the regular price of a commodity. This is usually found by deducting the selling price from the regular or marked price of a commodity. Discount can also be expressed in percentage by taking the regular price multiplied by the rate of discount. Regular Price × Rate of Discount =