For example, 75% is read as “Seventy-five percent” and is equivalent to 75/100 or 0.75.
Accordingly, the values in column E are decimals.
Get percentage discount
To calculate the percentage discount from an original price and a sale price, you can use a formula that divides the difference by the original price. In the example shown, the formula in E5, copied down, is: =(C5-D5)/C5 The result is a decimal value which is formatted with the percentage number format.
