How to Subtract a Percentage in Excel (Easiest Way in 2025)

In this article, we will show you how to subtract a percentage in Excel. Simply follow the steps below.

Subtract a Percentage in Excel

To subtract percentages in Excel, we will work with a dataset containing item names in Column A, original prices in Column B, and discount percentages in Column C. Follow the steps below:

1. Input the Formula to Calculate Price After Discount

In a cell next to your data, input the formula to calculate the new price after applying a discount. In our example, we will enter the formula =B2*(1-C2) in cell D2, where B2 holds the original price and C2 contains the discount percentage for the first item. 

This formula calculates the discounted price by reducing the original amount by the given percentage.

2. Apply the Discount Formula and Calculate New Prices

After entering your formula, press Enter to apply it. We will now see the discounted price appear in cell D2. 

3. Copy the Discount Formula to Other Items

To apply the discount calculation to multiple items, drag the fill handle from the formula cell to other cells down the column. 

This action auto-adjusts the formula for other rows, ensuring all items receive the correct discounted calculation.

We hope that you now have a better understanding of subtracting a percentage in Excel. If you enjoyed this article, you might also like our articles on how to copy a protected Excel sheet without a password and how to subtract two columns in Excel.