In Microsoft Excel, working with percentage change, percentage increase, or percentage decrease is one of the familiar tasks. We calculate the percent change in a lot of calculations. To do these calculations, you have to understand the Excel formula for percentages. In this tutorial, you will learn to calculate percentage increase in Excel along with other percentages topics. This tutorial will be on point with suitable examples and their proper illustrations. So. stay with us.

## Calculate Percentage of a Number in Excel

Before we start, we have to know first how to calculate a percentage in Excel.

Let’s assume that you are giving an Exam. There are *50 *questions. You’ve answered all of them. And *35* of them are correct. So, calculate your percentage of correct answers in Excel.

📌 **Steps:**

- First, divide
*35*by*50*.

- Then, press
**Enter**.

- Go to the
**Number**group. - Next, click on the
**Percentage (%)**sign.

- Look at the result below.

As you can see, *70% *of your answers are correct. In this way, you can calculate the percentage increase in Excel.

## Calculate Percentage Increase in Excel with Examples

Now, let’s come to the main topic. If you are new to this, you may be wondering how to calculate the percentage increase in Excel. It is pretty simple to compute. Let’s discuss the percentage increase formula.

**Excel formula for Percentage Increase:**

**Percentage Increase = (New value – Original Value) / Original Value**

Suppose, you bought something for a price of *$100* in *September*. Now, in *October*, the price became *$150*. So,

**Increase = (150-100)/100 = 0.5 = 50%
**It means there is a

*50%*increase in the price.

In the following sections, I am going to show you some examples of the percentage increase in Excel. I recommend you learn and apply all these methods to your dataset to calculate the percent increase. It will surely come in handy in the future.

### 1. Calculate Percentage Increase in Marks

Have a look at the following dataset.

Here, we have some students’ marks in the dataset. You can see their performance in a particular subject in the *Summer* and *Fall *semesters. Surely, there is a difference in their marks. So, we are going to calculate the percentage increase using the Excel formula.

📌 **Steps:**

- First, select cell
**F5**and type the following formula.

`=(E5-D5)/D5`

- Press
**Enter**and drag the**Fill Handle**icon over the range**F6:F11**.

- You will see the increase in decimal format. To change this to percentages, go to the
**Number**group in the**Home**tab.

- Next, click on the
**Percentage (%)**sign.

In the end, you will see all the increases in percentage format in Excel.

**Read More:** How to Calculate Average Percentage Increase for Marks in Excel Formula

### 2. Percentage Increase of Sales Formula in Excel

Have a look at the following dataset.

Here we have the yearly sales data of a company. Our goal is to calculate the percentage increase in sales using the increase percentage formula in Excel. We are using the previous formula here. Let’s dive into it.

📌 **Steps****:**

- Select cell
**D6**and type the following formula.

`=(C6-C5)/C5`

- Then, press
**Enter**and drag the**Fill handle**icon over the range**D7:D11**.

- Now to change this to percentages, go to the
**Number**group in the**Home**tab.

- Finally, click on the
**Percentage (%)**sign.

As you can see, we are successful in calculating the percentage increase of the yearly sales data above.

**Read More:** How to Calculate Percentage Increase from Zero in Excel

## Increase a Value by a Particular Percentage in Excel

Now, you can find the new value after increasing a specific percentage to the original value.

**The Generic Formula:**

**New value = Original Value+ (Original Value * Percentage)**

Have a look at the dataset.

Here, you can see the price of some products. Now, you want to calculate the new price after increasing the price by a specific percentage. So, calculate using the previous formula.

📌 **Steps:**

- Move to cell
**E5**and type the following formula.

`=C5+(C5*D5)`

- Next, press
**Enter**and drag the**Fill handle**icon over the range**E6:E11**.

As you can see, we have successfully calculated all the new values after increasing them by a specific percentage in Excel.

## Compute Percentage Decrease in Excel

Now, similar to the percent increase, you can also calculate the percentage decrease in Excel. The main difference is we are subtracting the new value from the original value. If you don’t do that, it will show you a negative sign.

**Excel Formula for Percentage Decrease:**

**Decrease = (Original Value – New Value) / Original Value**

Suppose, you bought something for a price of

*$100*in

*September*. Now, in October, the price became

*$50*. So,

**Decrease = (100-50)/100 = 0.5 = 50%**

It means there is a

*50%*decrease in the price.

Have a look at the dataset.

We have the prices of some products. You can see there is a decrease in the price between *October* and *November*. We are going to calculate the decrease in the percentage.

📌 **Steps:**

- Type the following formula on cell
**E5**.

`=(C5-D5)/C5`

- Next, press
**Enter**and drag the**Fill handle**icon over the range**E6:E11**.

- To convert this to percentages, go to the
**Number**group in the**Home**tab.

- Next, click on the
**Percentage (%)**sign.

As you can see, we have successfully calculated the percentage decrease in price in Excel.

## How to Show Increase or Decrease in Excel Using VBA

Now, there are various ways to show a percentage increase or decrease in a dataset. One of them is using the **VBA** code. If you are a VBA freak like me, you will definitely like this one.

Have a look at the dataset.

Here, we have almost a similar dataset to the previous one. But, if you look closely at the dataset, we have an increase, decrease, and no difference in some prices. Our goal is to use the VBA codes to find whether there is a decrease, increase, or no change in the price.

📌 **Steps:**

- Press
**Alt+F11**on your keyboard to open the VBA editor. - Then, select
**Insert > Module**.

- After that, type the following code.

```
Sub increase_or_decrease()
Dim result As Integer
Dim i As Integer
For i = 5 To 11
If (Cells(i, 3).Value > Cells(i, 4).Value) Then
result = ((Cells(i, 3).Value - Cells(i, 4).Value) / Cells(i, 3).Value) * 100
Cells(i, 5).Value = result & "% Decrease"
ElseIf (Cells(i, 3).Value < Cells(i, 4).Value) Then
result = ((Cells(i, 4).Value - Cells(i, 3).Value) / Cells(i, 3).Value) * 100
Cells(i, 5).Value = result & "% Increase"
Else
Cells(i, 5).Value = "No change"
End If
Next i
End Sub
```

- Then, save the file.
- After that, press
**Alt+F8**on your keyboard to open the**Macro**dialog box. - Next, select
**increase_or_decrease**macro and click on**Run**.

- Look at the dataset.

Isn’t that great? VBA codes are always useful to perform a calculation over a large dataset or numerous worksheets or workbooks. So, we are successful in showing an increase or decrease in percentages using the VBA codes in Excel.

**Read More: **How to Calculate Price Increase Percentage in Excel

## Percentage as a Proportion of a Number in Excel

Now, Excel can assist you in estimating a percentage as a proportion. It is a distinction between one number as your entire figure and a shorter number. It needs a more straightforward mathematical computation than a percentage modification.

Have a look at the following dataset.

The scenario is that you have to pay an amount of *$1000*. But, you have paid *$725*. Now, what will be the percentage proportion of your payment? And what will be the percentage proportion of your due amount?

📌 **Steps:**

- Select cell
**D5**and type the following formula.

`=C5/B5`

- Next, press
**Enter**. - You will see the increase in decimal format. To change this to percentages, go to the
**Number**group in the**Home**tab. Then, click on the**Percentage (%)**sign.

- After that, select cell
**D5**and type the following formula.

`=100%-D5`

- Finally, press
**Enter**.

As you can see, you have paid *73%* of your debt and it is due *28%* (approximate). In this way, you can find the percentage as a proportion number.

**Read More: **How to Calculate Average Percentage Increase in Excel

## Imply Discount Percentage Based on Conditions in Excel

Suppose, you have a shop. Numerous people come to your shop to buy things. Now, you want to give them discounts based on their customer status. The conditions are the following:

- If someone is a
*VIP*customer, give them a*30%*discount. - If someone is a
*Regular*customer, give them a*15%*discount. - No discount for new customers.

Now, our goal is to calculate the percentage of the numbers or amounts using the previous formula.

To apply this, we are using **the IF function** for the conditions.

To demonstrate this, we are using this dataset.

📌 **Steps:**

- First, select cell
**D5**and type the following formula.

`=IF(C5="VIP",(1-30%)*B5,IF(C5="REGULAR",(1-15%)*B5,B5))`

- After that, press
**Enter**and drag the**Fill Handle**icon over the range**D6:D11**.

As you can see, only *VIP* and *REGULAR* category customers get discounts. In this way, you can perform various calculations with Excel for a percentage.** **

## Find the Actual Price Based on the Amount and Percentage

Now, this is a typical math problem. I am showing this to you so that you can remember these operations easily and perform them in your Excel worksheets. You will find yourself in situations like this while working with percentages.

Suppose, you have bought a laptop for *$500* that is *75%* of its original value. Now, what was the actual price of that laptop?

**The Generic Formula:**

**Actual Price = Buying Price / Percentage**

To demonstrate this, we are using the following dataset.

📌 **Steps:**

- Select cell
**D5**and insert the following formula.

`=B5/C5`

- After that, press
**Enter**.

As you can see, we used the Excel formula to calculate the actual price after implying the percentage.

## Find the Amount Based on the Tax Percentage in Excel

Suppose, you want to buy a flat which is worth* $150K*. To buy this, you have to pay *7.8% *tax. What will be the addition that you have to pay because of the *7.8%* tax? We will calculate the total amount based on its percentage.

**The Generic Formula:**

**Additional Amount = Buying Price * Tax Percentage**

📌 **Steps:**

- First, select cell
**D5**and type the following formula.

`=B5*C5`

- After that, press
**Enter**.

As you can see, you have to pay an additional *$11700* because of the *7.8%* tax. So, you are successful in calculating the increase based on tax percentage.

## Common Errors While Dealing with Percentage in Excel

Now, while working with the percentage format in Excel, you may face these types of errors :

**#DIV/0!**: If you try to divide a percentage by zero, it will happen. To crack this issue, modify the divider into a number that is not zero.**#VALUE!**: This appears when you select a blank cell while calculating. When a function is expecting a number but you give it text, it will occur.**#NUM!**: It will occur if your formula contains an invalid percentage.**#NAME?**: If you type incorrect values in the formula, like a misspelling of a function. To correct it, write proper formula names.**#REF!**: You may find this error if you are referencing an invalid cell. Also, it will occur if you have deleted a cell that is needed for the formula. To rectify this, select the correct cell references.**####**: This is not a problem. You may find this if your data does not fit with the column. The answer is to extend the individual column.

## 💬 Things to Remember

✎ To get a percentage difference, you must provide two values.

✎ Your formula will show a negative percentage for decrease if your original value is bigger than the new value. To solve this, try to subtract the new value from the original value.

✎ Excel will show decimal places for percentages. For this reason, change the format from decimal to percentage by the Excel **Ribbon**. Or you can use the shortcut: **Ctrl+Shift+%**.

**Download Practice Workbook**

## Conclusion

To conclude, I hope this tutorial has provided you with a piece of useful knowledge to calculate the percentage increase in Excel. We recommend you learn and apply all these instructions to your dataset. Download the practice workbook and try these yourself. Also, feel free to give feedback in the comment section. Your valuable feedback keeps us motivated to create tutorials like this.

**<< Go Back to Percentage Change | Calculating Percentages | Calculate in Excel | Learn Excel**