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 percentage. 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.
Download Practice Workbook
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 50 by 35.
- Then, press Enter.
- After that, go to the Number group.
- Next, click on the Percentage sign (%).
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 here their performance in a particular subject in Summer and Fall. 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
- After that, press Enter and drag the Fill handle icon over the range of cells F6:F11.
- You will see the increase in decimal format. To change this to percentage, 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 of the sales using the increase percentage formula in Excel. We are using the previous formula here. Let’s dive into it.
📌 Steps
- First, select Cell D6 and type the following formula:
=(C6-C5)/C5
- After that, press Enter and drag the Fill handle icon over the range of cells D7:D11.
- Here, you will see the increase in decimal format. To change this to percentage, go to the Number group in the Home tab.
- Finally, click on the Percentage sign (%).
As you can see, we are successful to calculate the percentage increase of the yearly sales data above. Try this in your spreadsheet.
Read More: How to Calculate Percentage Increase from Zero in Excel (4 Methods)
Increase a Value by a Particular Percentage in Excel
Now, you can find the new value after increasing a specific percent to the original value. It is quite simple to calculate.
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 percent. So, calculate using the previous formula.
📌 Steps
- At first, select Cell E5 and type the following formula:
=C5+(C5*D5)
- Next, press Enter and drag the Fill handle icon over the range of cells E6:E11.
As you can see, we have successfully calculated all the new values after increasing them by a specific percentage in Excel.
Related Content: How do you Calculate Percentage Increase or Decrease 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,
Increase = (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 price 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
- First, select Cell E5 and type the following formula:
=(C5-D5)/C5
- Next, press Enter and drag the Fill handle icon over the range of cells E6:E11.
- After that, you will see the increase in decimal format. To change this to percentage, 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.
Read More: How to Calculate Percentage Change with Negative Numbers in Excel
How to Show Increase or Decrease in Excel Using VBA
Now, there are various ways to show a decrease or increase 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 it is a decrease, increase, or no change in the price.
📌 Steps
- First, 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.
- Then, click on Run.
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 (3 Easy Ways)
Percentage as a Proportion of a Number in Excel
Now, Excel can furthermore assist you to estimate a percentage as a proportion. It is a distinction between one number as your entire figure and a shorter number. It needs an actual more straightforward mathematical computation than a percentage modification.
Have a look at the following dataset:
The scenario is: 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
- First, select Cell D5 and type the following formula:
=C5/B5
- Next, press You will see the increase in decimal format. To change this to percentage, 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 of 28% (approximate). In this way, you can find the Percentage as a proportion number.
Read More: How to Calculate Percentage Between Multiple Numbers 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 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 of cells 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 Excel Formula:
Actual price = Buying Price / Percentage
To demonstrate this, we are using the following dataset:
📌 Steps
- First, select Cell D5 and type 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, are successful to calculate 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 is not fitting 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+%.
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.
Don’t forget to check our website ExcelDemy.com for various Excel-related problems and solutions.
Keep learning new methods and keep growing!