Calculate the Percentage Increase in Excel
To calculate the percentage increase in excel is easy as this requires the use of a simple formula that can be easily designed. Calculating the percentage increase shows how much there has been a change in the value but in terms of percentage increase instead of showing the delta as a Value.
- The percentage increase is possible when the old value is less than the new value; this is because if the old value is more than the new value than there will be a percentage decrease and not a percentage increase.
- A percentage is quite difficult to understand and format as they are not easy to format. Suppose we are formatting the cell as a percentage, then there are some basic rules of percentages that must be followed. If we have a value in a cell and we format that cell as a percentage, then we will get a percentage that is multiplied by 100 by excel.
- So, if we have “17” as a value in the cell and we format that cell as a percentage, then we will get 1700% as a result.
- If we get the solution to this formula as a positive percentage difference in excel, then this is a percentage increase, but if the result is a negative percentage, then this is not a percentage increase but a percentage decrease.
For calculating the percentage increase, we need to formulate a function that first calculates the increase in the new Value and then calculates the ratio that has been occupied by the new value.
By using the above excel functionExcel FunctionExcel functions help the users to save time and maintain extensive worksheets. There are 100+ excel functions categorized as financial, logical, text, date and time, Lookup & Reference, Math, Statistical and Information functions., we can easily calculate the percentage increase in excel.
Examples to Calculate Percentage Increase in Excel
Below are the following examples to calculate the percentage increase in excel.
Method #1 – Percentage Increase in Columns
This method should be used when we have horizontally plotted data, i.e., the data is in columns instead of rows. The common example of horizontally placed data is Profit during the year, marks obtained by the student in various exams, etc.
- To calculate the percentage increase first, we need to check that the new value is greater than the old value or not. If there is any value that is less than the old value, the formula may give an insignificant result.
The data is given below:
- Insert the below formula in cell and press enter.
- The output is:
- Apply the formula to other cells to get the result.
- After the formula is inserted and executed, then we need to format the cell to percentage to get the result as a percentage.
- You can increase the percentage, as shown below.
Method #2 – Percentage Increase in Rows
This method should be used when we have Vertical data, i.e., when the data is in Row and not in columns. Obviously, the data will be in the column, but there should only be one column to use this method.
This method is useful in cases where change needs to be shown vertically; the example of this data can be the profit during various months of the same year.
- Step #1
We can calculate the percentage increase from the second row only because there will be no base data for the first row.
- Step #2
Insert the below function in a row.
we got the result as given below.
Apply the excel formulaExcel FormulaThe term "basic excel formula" refers to the general functions used in Microsoft Excel to do simple calculations such as addition, average, and comparison. SUM, COUNT, COUNTA, COUNTBLANK, AVERAGE, MIN Excel, MAX Excel, LEN Excel, TRIM Excel, IF Excel are the top ten excel formulas and functions. to other cells to get the result.
- Step #3
After the function has been executed, format the cell as a percentage to get the result in a percentage.
Method #3 – Percentage Increase in Value
This method should be used when we have only base value, and we need to calculate a new value. This means that there is no Old value and new value in this case.
In this case, we have to calculate the new value by adding the defined percentage. Not only can we calculate the percentage increase between the two values, but we can also calculate the percentage increase in the same value also.
- Step #1
To calculate the percentage increase in old value, first, we need to mention the required percentage increase in a separate column.
- Step #2
Now insert the below formula to calculate the new value that will be increased by the defined percentage.
The output is given below:
Apply the formula to other cells to get the result.
- Step #3
Now, all we need is to format the cell as a percentage, and we will get the result in a percentage.
Things to Remember
- Percentage increase can only be calculated if both the data is quantitative; percentages cannot be calculated for qualitative data.
- The percentage increase can only be calculated if the new value if greater than the old value. This is because, for a percentage increase, the value should have a rise and not a decline; if there is a decline in value, then there will be a percentage decrease.
- We need to format the cell as a percentage to display the result as a percentage and not a value.
This has been a guide to Calculate Percentage Increase in Excel. Here we learn How to Calculate Percentage Increase in Excel along with practical examples and a downloadable template. Below you can find some useful excel articles –