There are a few things you need to know in order to calculate percent increases in Excel. The first is that the formula for calculating percent increases is P(A+B) where A and B are the changes in the original data and P is the percentage increase. The second thing you need to know is that Excel will automatically round up or down when it calculates percent increases. So if you have a data set of 100,000 values and want to calculate a percent increase of 10%, then Excel would round up to 10%. However, if you have a data set of 100,000 values and want to calculate a percent increase of 5%, then Excel would round down to 5%. The last thing you need to know is that there are two different ways that Excel can display percentage increases. The first way is as text boxes on the left side of the spreadsheet while the second way is as bars on the right side of the spreadsheet. So if you want to see how much each value has increased since your original data set was collected, then use either method!
If you can calculate percentages in Excel, it comes in handy. For example, you might need to calculate the tax on a sale, or the percentage of change in sales from last month to this month. Here’s how you do it!
Calculate Percent Increase
To get started, let’s calculate the increase of one value over another as a percentage.
In this example, we want to find the percentage of increase in the sales of a product this month compared to last month. In the image below, you can see last month’s value of 430 in cell B3, and this month’s sales of 545 in cell C3.
To calculate the difference as a percentage, we subtract this month’s value from last month’s, and then divide the result by last month’s value.
The brackets around the subtraction part of the formula ensure that calculation occurs first.
To format the result as a percentage, click the “Percent Style” button in the “Number” section on the Home tab.
We see the percentage of increase is 27 percent.
If the percentage is negative, it means the sales of the product have decreased.
Increase a Value by a Specific Percent
You can also increase a value by a specific percentage.
In this example, we want to increase the price of a product by five percent. To do this, we can multiply the product price by 1.05. This is shown in the formula below:
Or we could write the formula as:
These formulas simply multiply the value by five percent more than the whole of itself (100 percent).
As a result, a 20 percent increase would be multiplied by 120 percent, and a 15 percent increase would be 115 percent (or 1.15).
