To get the percentage discount, we require the original price of the product as well as the discounted price of the product.

Percentage Discount

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:

Percentage Discount

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:

Percentage Discount

As you can observe in the image above, we have added the “minus” sign to create the difference.

Percentage Discount

Then we will select the Discounted Price i.e. cell E3 in the example above.

Percentage Discount

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.

Percentage Discount

So overall, the formula becomes:

=1-(E3/C3)

Now all we have to do is press “enter”.

Percentage Discount

The answer came out as 0.08.

Percentage Discount

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:

Percentage Discount

We need to go to the “number” section and select the Percentage in the same. (As shown in the image above)

Percentage Discount

So, there you go, with the percentage discount provided on the product as per the original price as well as the discounted price.

Percentage Discount

It’s easy, isn’t it?

Learn: How to Sort cells if a cell is x OR y AND Z?