To get the percentage discount, we require the original price of the product as well as the discounted price of the product.
Previously: Calculate retirement date with EDATE Formula
As you can observe in the image above, we have taken example of a bunch of products with their original price as well as discounted price. To figure out the discount percentage, here’s what we do:
The first thing we will do is put the “equal to” sign. As every formula begins with an equal to sign so its important to include the same.
Then we will write 1, as we will be subtracting the discounted price by original price from 1.
To understand the same, let’s continue:
As you can observe in the image above, we have added the “minus” sign to create the difference.
Then we will select the Discounted Price i.e. cell E3 in the example above.
Then we will divide the same by original price, so we will select the same. In the above example, cell C3 is the original price.
So overall, the formula becomes:
Now all we have to do is press “enter”.
The answer came out as 0.08.
Now drag the same formula down so that your work gets easy.
As you can observe in the image above that the values are not in the percentage, so to do the same, this is what we will do:
We need to go to the “number” section and select the Percentage in the same. (As shown in the image above)
So, there you go, with the percentage discount provided on the product as per the original price as well as the discounted price.
It’s easy, isn’t it?