Certainly, calculating percentages is a common task in our day-to-day lives. In countless situations, you may need to subtract a percentage, and this is where Microsoft Excel excels. In this tutorial, we’ll show 3 easy ways to **subtract a percentage in Excel**. Moreover, we’ll also discuss subtracting a percentage from a number and subtracting a percentage from a column in Excel.

**Table of Contents**hide

## Download Practice Workbook

## 3 Ways to Subtract a Percentage in Excel

Considering the **Percentage of Total and Spent Amount** dataset shown in the **B4:C13** cells. Here, we have the **Total Amount **and the **Spent Amount **in percentages while we want to obtain the **Left Amount **in percentages. So, without further delay let’s see each method in detail.

Here, we have used the *Microsoft Excel 365* version, you may use any other version according to your convenience.

__Method-1__: Subtracting Percentage Value

Let’s begin with the simplest and the most obvious method, that is to say, we’ll subtract one percentage value from another using the expression below.

**Minuend Percentage** – **Subtrahend Percentage**

where:

- The
is the number that is to be subtracted from.*minuend* *Subtrahend*is the number that is to be subtracted.

Hence, let us write this expression in Excel.

📌 ** Steps**:

- First and foremost, go to the
**D5**cell >> enter the formula given below.

`=B5-C5`

Here, the **B5 **and **C5** cells refer to the *Total* and *Spent Amounts* respectively.

- Now, this returns the
*Left Amount*as*20%*>> then, use the**Fill Handle Tool**to copy the formula into the cells below.

Finally, the results should look like the image given below.

__Method-2__: Subtracting Percentage from Price

For our second method, we’ll subtract a percentage value from the usual price of an item. Now, consider the **Price List of Cellphones** dataset shown in the **B4:D13 **cells, which shows the **Cellphone** model, **Actual Price **in USD, and the **Price Decrease **in percentage. Here, we want to calculate the **Updated Price **of the cell phones considering the price cut.

#### 2.1 Conventional Way

Let’s see the conventional way of obtaining the new price after factoring in the price decrease of an item.

📌 ** Steps**:

- In the first place, move to the
**E5**cell >> insert the following expression.

`=C5-(D5*C5)`

In this expression, the **C5 **and **D5 **cells represent the *Actual Price *and the *Price Decrease *respectively.

- Next, copy the same formula to other cells and your output should look like the picture shown below.

#### 2.2 Advanced Method

Alternatively, there is an advanced method of subtracting a percentage from a price that gives the same results. So, follow the steps shown below.

📌 ** Steps**:

- First of all, navigate to the
**E5**cell and type in the equation given below.

`=C5*(1-D5)`

In the above equation, the **C5 **and **D5 **cells point to the *Actual Price *and *Price Decrease *respectively.

- Afterward, apply the same formula to the cell below and the output should look like the screenshot given below.

__Method-3__: Subtracting a Fixed Percentage (30 Percent/10 Percent)

Another common scenario involves subtracting a fixed percentage value from a list of given prices. Here, we want to calculate the discounted price of the cell phones, considering a 30% discount on the actual prices. Therefore, let’s see it in action.

📌 ** Steps**:

- To begin with, proceed to the
**D5**cell and type in the expression into the**Formula Bar**.

`=C5*(1-$C$15)`

In this case, the **C5 **cell indicates the *Actual Price* of the cell phone in USD while the **C15** cell refers to the *Discount* in percentage.

📃 *Note: **Please make sure to use **Absolute Cell Reference** by pressing the F4 key on your keyboard.*

Eventually, the *Updated Prices* should look like the image given below.

- In a similar fashion, if we change the
*Discount*rate to*10%*the results should look like the picture shown below.

## How to Subtract a Percentage from a Number

Assuming that the **List of Numbers** dataset is shown in the **B4:C12 **cells where we have a list of **Numbers **and the **Reduce By **values in percentage. Now, we want to subtract these percentage values from the numbers, hence, just follow along.

📌 ** Steps**:

- First, jump to the
**D5**cell >> enter the expression given below.

`=B5-(B5*C5)`

In this expression, the **B5 **and **C5 **cells represent the *Number *and *Reduce By *values, respectively.

Consequently, your output should look like the screenshot shown below.

## How to Subtract a Percentage from a Column in Excel

What if you want to subtract a percentage from an entire column in Excel? Well, you’re in luck because the following section answers this exact question. Here, we’ll subtract a percentage from the actual price to get the new price of the cell phones. Now, allow me to demonstrate the process in the steps below.

📌 ** Steps**:

- At the very beginning, proceed to the
**C16**cell >> insert the equation given below.

`=100%-C15`

In this instance, the **C15** cell points to the *15% Discount*.

Now, this calculates the *Remaining Percentage* value of *85%*.

- Next, press
**CTRL + C**to copy the*Actual Price*>> hit the**CTRL + V**keys to paste the values into the*Updated Price*column.

- Then, copy the
*Remaining Percentage*value >> select the**D5:D13**cells >> press the**CTRL + ALT + V**keys on your keyboard.

In an instant, the **Paste Special** window appears.

- In turn, select the
**Values**and**Multiply**options >> click the**OK**button.

Subsequently, the *Updated Prices* column should look like the image shown below.

## Practice Section

We have provided a** Practice** section on the right side of each sheet so you can practice yourself. Please make sure to do it by yourself.

## Conclusion

Last but not least, we hope this tutorial has provided you with helpful knowledge on **how to subtract a percentage in Excel**. Now, we recommend you apply all this know-how in the practice dataset by downloading the practice workbook. In addition, feel free to comment and provide your valuable feedback.