In today’s tutorial I’m going to show you how to subtract percentage in Excel. For conducting the session I’m using Microsoft Excel 2019, you can use the version you have in your PC (Excel 2010, Excel 2013, Excel 2016, Excel 2019) or the web version of Microsoft Excel. Not only that, you can use Google Sheets as well. Plenty of options!

So, further ado, let’s begin today’s journey. But, first things first, let’s know about today’s practice worksheet.

We have two different tables. Table at the top has three columns, **Total Amount**, **Amount Spent**, **Amount Left**. Values are stored in percentage format. Using this table, we will subtract two percentage values.

Table at the bottom has five columns, **Cellphone**, **Price**, **Price Decrease**, **Updated Price(Basic)**, **Updated Price(Advanced)**. By this table, we will subtract a percentage from a value.

## Practice Workbook

For your convenience, I have given the link to today’s workbook. You can download it from here.

## 1. Subtract Percentage Value in Excel

If you want to subtract a percentage value from another, it will be the simple minus formula.

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

*Minuend** is the number, that is to be subtracted from*

*Subtrahend** is the number, that is to be subtracted*

So, in simple terms,

**The Percentage from which you need to subtract – The Percentage that you need to subtract**

Let’s write it in Excel.

We have subtracted **Amount Spent** from **Total Amount** and got **Amount Left**. Simple! Our calculations will be done by using **Cell Reference**.

Write the formula for the last one. When you have a large data set, it’s useful to use Excel **AutoFill**.

## 2. Decrease Number by Percentage in Excel

You may need to subtract a percentage from a value. In this section we will see how to do that. There is a basic formula and an advanced formula to calculate that. I’m listing both methods here. You can choose your preferred one.

### 2.1. Conventional Way

Let’s see the formula first.

**Original Value – (Percentage * Original Value)**

Let’s write it on the Excel sheet.

We have multiplied the **Price Decrease **(Usually for a product decrease percentage means** Discount)** with **Price** and subtracted the result from the **Price**. And it gave the **Updated Price**.

For the rest of the rows feel free to write the formula or simply use the **AutoFill** feature of Excel.

### 2.2. An Advanced Method

Enough of the usual method, let’s do something new. The advanced formula is as follows.

**Original Value * (1-Percentage)**

When you are going to subtract a percentage from a value, which means you will subtract the Given Percentage of Original value from the 100% of Original Value. You can imagine the value like **(100% – Given percentage) of the Original Value**. 1 is the decimal equivalent of 100%.

*So, when you are subtracting a percentage value from 1, it will subtract the decimal equivalent of that percentage from 1.*

Now you can write the formula for the rest of the rows or simply use Excel **AutoFill**.

## Useful Tips

Now you may want to see the values up to a preferred decimal place. You can do that easily. Explore the **Number** section of the **Home** tab, you will find **Increase Decimal** and **Decrease Decimal** options.

Use the option you like. Here I’m using **Decrease Decimal**.

Excel will do the calculation automatically to round the figure. You can increase decimal points by using the **Increase Decimal** option.

You can change decimal in another way also. On the **Number** section, click on the list icon then go to **More Numbers Formats**

In the dialog box you will find a placeholder to select decimal places. Feel free to choose how many decimal points you want.

## Conclusion

That’s all for today’s session. I tried listing out ways of subtracting a percentage in Excel. Hope you will find it helpful. Do comment if anything seems hard to understand. Let me know which of the options you are going to use. You can also write your own way to do the task.

## Percentage Subtraction Calculator

You can use today’s workbook as a calculator to subtract a percentage. You will find the workbook consists of two sheets. For using the calculator, go to the sheet named, **Percentage Sub Calculator. **

You will see three placeholders, **Value**, **Percentage**, **% Subtracted. **

At 1 insert the amount from where you want to subtract

At 2 provide the percentage

You have done your part, now you will find the result you are looking for at 3.

## Further Readings

- Percentage Difference between Two Percentages Excel (2 Easy Ways)
- Calculate Average Percentage in Excel [Free Template+Calculator]
- How do you Calculate Percentage Increase or Decrease in Excel
- Excel Formula to Add Percentage Markup [with Calculator]
- Calculate Excel percentage difference between two numbers (using formula)