The result should reflect the discount applied to the old price. In c4, enter the equation =B4 * (1-Discount). I'll assume your existing prices are in column B (with a product codes in column A), starting in row 4. Now we need to apply the discount to your prices. How do you calculate a discount in Excel?Įnsure that Excel is creating the name Discount and that it references B1.