Question: how do you calculate percentage of discount?
Answer: First, divide the discounted price by the original price. ...  Subtract this result from 1. ...  On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format.