If you know the original price and the discounted price, you can calculate the percentage discount.
1. First, divide the discounted price by the original price. ...
2. Subtract this result from 1. ...
3. On the Home tab, in the Number group, click the percentage symbol to apply a Percentage format.
Calculate Percentage Discount - Easy Excel Tutorial www.excel-easy.com > examples > discount
To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.
How to do percentages in Excel | Microsoft 365 Blog
www.microsoft.com > en-us > microsoft-365 > blog > 2011/08/02 > how-t...
The formula to calculate the discount rate is: Discount % = (Discount/List Price) × 100.
Discount rates, Formulas, Types - Cuemath
www.cuemath.com > commercial-math > discounts