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.
=(C3-B3)/B3
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.
Post a Comment Blogger Facebook
We welcome comments that add value to the discussion. We attempt to block comments that use offensive language or appear to be spam, and our editors frequently review the comments to ensure they are appropriate. As the comments are written and submitted by visitors of The Sheen Blog, they in no way represent the opinion of The Sheen Blog. Let's work together to keep the conversation civil.