**Subtracting percentages** is a very common affair in our day-to-day life. Especially when we need to calculate any price without a discount, we need to subtract that discount rate in **percentage**. **Microsoft Excel** has made this subtraction a lot easier. In this article, we will learn how to **subtract 10 percent** in excel in 3 easy ways. Afterward, we will also show the process of subtracting 10 percent from a column. So without further delay, letâ€™s hop into the methods.

**Table of Contents**hide

## Download Practice Workbook

Download the worksheet and practice by yourself.

## 3 Easy Ways to Subtract 10 Percent in Excel

To illustrate the processes, we have prepared a sample dataset here. It shows the information on** 5 **types of **Products** with their **Prices** in **columns B** and **C**.

Now, we will **subtract 10 percent** from each of the productâ€™s prices to get the new price following the methods below.

### 1. Use Conventional Method to Subtract 10 Percent

In this first method, we will apply the conventional method in excel to subtract 10 percent. Letâ€™s see the process below.

- First, type this formula in
**cell E5**.

`=C5-(D5*C5)`

- Then, press
**Enter**and you will see the new price after a 10 percent deduction.

- Following, apply the
**AutoFill**tool up to**cell E9**to get all the new prices after subtracting 10 percent.

**Read More: ****How to Subtract a Percentage from a Price (4 Methods)**

### 2. Subtract 10 Percent with Advanced Formula

Here is another process to subtract 10 percent with an advanced formula in excel. Follow the steps below.

- First, insert this formula in
**cell E5**.

`=C5*(1-D5)`

- Next, hit
**Enter**to get the first price after 10 percent subtraction.

- Lastly, copy this formula in
**cell range E6:E9**to get the final output.

**Read More: ****Percentage Formula in Excel (6 Examples)**

**Similar Readings**

**How to Calculate Contribution Percentage with Formula in Excel****Calculate Percentage of Percentage in Excel (2 Examples)****How to Calculate Percentage of Completion in Excel (3 Methods)****Calculate Gross Profit Margin Percentage with Formula in Excel****How to Add Percentage to Price with Excel Formula (2 Ways)**

### 3. Insert Another Cell Reference for Subtraction in Excel

In this last section, we will try to take reference from another cell to subtract 10 percent. Here is the process to do this.

- First, type
**10%**in**cell C11**.

- Then, select
**cell D5**and type this formula.

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

**Note:**Donâ€™t forget to insert

**cell C11**as an

**Absolute Cell Reference**by pressing

**F4**on your keyboard.

- Afterward, press
**Enter**to get the new price.

- Lastly, use the
**AutoFill**tool to get the final output in**cell range D6:D9**.

**Read More: ****Calculate Percentage Using Absolute Cell Reference in Excel (4 Methods)**

## How to Subtract 10 Percent from a Column in Excel

So far, we learned to subtract 10 percent from cells. But what to do when you want to subtract a percentage from an entire column? In this section, we will give a quick solution to this. Carefully follow the process.

- In the beginning, type
**10%**in**cell C11**.

- Then, type this formula in
**cell C12**.

`=100%-C11`

- Afterward, press
**Enter**to get the**Remaining Percentage**.

- Now, copy the
**cell range C5:C9**by pressing**Ctrl + C**. - Following, paste it on the
**cell range D5:D9**by pressing**Ctrl + V**.

- Next, select
**cell C12**and press**Ctrl + C**to copy the value. - Then, select the
**cell range D5:D9**and press**Ctrl + Alt + V**.

- Right after that, you will see the
**Paste Special**dialogue box. - Here, select
**Values**as the**Paste**option and**Multiply**as**Operation**.

- Lastly, press
**OK**. - Thatâ€™s it, you will get the new prices all at once after subtracting 10 percent.

**Read More: ****Calculate Percentage in Excel VBA (Involving Macro, UDF, and UserForm)**

## Conclusion

Henceforth, we hope it was a helpful article for you on how to subtract 10 percent in excel in 3 easy ways. We also tried to guide you on subtracting 10 percent from an entire column. Let us know your suggestions in the comment box. Follow **ExcelDemy** for more Excel tutorials.

## Related Articles

**Use IF and Percentage Formula in Excel (2 Easy Ways)****How to Calculate Percentage in Excel Based on Cell Color (4 Methods)****Calculate Percentage of a Number in Excel (5 Easy Ways)****How to Calculate Total Percentage in Excel (5 Ways)****Calculate Average Percentage in Excel (3 Easy Methods)****Percentage Difference Between Two Percentages in Excel****Use Excel Formula to Calculate Percentage of Grand Total**