Excel is known for its prowess with calculations and data management, allowing you to easily compute information no matter how much data you’re working with.

A discount percentage is the number that represents how much you are saving on a purchase. If you have the original price and the discount price for a product or service, you can run a simple Excel formula to determine the percentage of the discount.

Excel is a great tool for calculating percentages and discounts with just a few clicks. In this article, we’ll show you how to calculate the discount percentage.

## Formula for Discount Percentage in Excel

Before calculating the discount percentage, you need to prepare your data, where…

**A2**is the cell with the original price.**B2**is the cell with the discounted price.

1. Click on the cell where you want to calculate the percentage of the price difference (**C2**).

2. Navigate to the **Formula** Bar.

3. Write the formula **=B2/A2**.

4. Then press the **Enter** key on your keyboard.

Just like that, you have determined the percentage of the discount price compared to the original price. However, the answer will not display as a percentage automatically. Let’s take a look at how to change that.

5. Right-click the cell with your percentage value.

6. Choose **Format Cells**.

7. Select **Percentage** from the category options.

8. Click **OK**.

That’s it! Super easy.

Now let’s calculate the percentage of the actual discount.

9. Click on the cell where you want to calculate the discount percentage.

10. Go to the **Formula** Bar.

11. Write the formula **=1-C2**, where **C2** is the cell with the percentage of the discounted price.

12. Press the **Enter** key on your keyboard.

And there you have it!

Looking for and taking advantage of discounts are a great way to save money. When you want to know just how much of a deal you’re getting on your purchase, use the method above to determine the discount percentage. For more tutorials covering basic calculations you need in your day-to-day life, read this guide on how to prorate in Excel.

With this simple step-by-step guide, you can easily calculate the percentage of your discount in seconds and organize your data with ease.