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.