Percentage Increase Calculator Excel
Calculate the percentage increase between two values and get the exact Excel formula to use. Enter the original and new values for the result plus a ready-to-paste spreadsheet formula.
Percentage Increase
—
The result plus the Excel formula. In Excel, put the original value in A1 and the new value in B1.
What is a percentage increase calculator for Excel?
A percentage increase calculator for Excel does two things at once: it calculates the percentage increase between two values, and it gives you the exact Excel formula to reproduce the result in a spreadsheet. This is useful when you need both a quick answer and a reusable formula for a worksheet.
The formula behind the calculation is ((new value − original value) / original value) × 100. In Excel, you put the original value in cell A1 and the new value in cell B1, then enter =(B1-A1)/A1 and format the cell as a percentage. Excel multiplies by 100 and adds the % sign automatically.
This tool is handy for analysts, accountants, and anyone building reports. Instead of remembering the formula and hoping the cell references are right, you get the percentage increase and the exact Excel expression together, so you can paste it straight into your worksheet and trust the result.
How to calculate percentage increase in Excel
- 1
Enter the original value
Type the starting number into the calculator, such as an old price or previous month's sales. In Excel, this goes in cell A1.
- 2
Enter the new value
Type the current or higher number you want to compare against. In Excel, this goes in cell B1.
- 3
Read the result and Excel formula
The calculator shows the percentage increase and the Excel formula =(B1-A1)/A1. Paste it into a cell and format as a percentage.
Why use this percentage increase calculator for Excel?
Result plus formula
Get the percentage increase and the exact Excel expression together, so you can verify the math and paste the formula into your worksheet.
Correct cell references
The formula uses A1 for the original value and B1 for the new value, matching the most common spreadsheet layout for before-and-after pairs.
Transparent method
Every result is built on the standard increase formula, so you can learn the method and adapt it to other cell references yourself.
FAQ
Frequently Asked Questions
Quick answers to common questions about percentage calculations.
Related Calculators
Explore More Tools
Explore more free percentage tools for decrease, change, difference, and share calculations.