Calculate Percentage Increase Between Two Numbers In Excel

Calculating Percentage Increase Between Two Numbers In Excel

Most people put the new number first and the old number second when subtracting, then divide by the wrong value. That's why you end up with numbers that don't make any sense compared to what you expected. The formula itself is straightforward once you get past the part where you have to decide which number represents what. The basic calculation is (New Value - Old Value) divided by Old Value. Then format the result as a percentage. That's the entire mechanics of it. When I built my first pivot table dashboard for quarterly revenue, I messed this up so badly on the first version that the percentage column was showing negative 340% on what should have been a normal decline. The issue wasn't Excel. It was that I had the reference cell in the denominator flipped to the new value instead of the old one.

Calculate Percentage Increase Between Two Numbers In Excel Step By Step

Put your original number in one cell and your new number in an adjacent cell. For example, let's say A2 has 45000 and B2 has 62000. In C2, you enter the formula =(B2-A2)/A2. Hit Enter and you'll get a decimal number like 0.3778. Click the percentage button in the Home tab or press Ctrl+Shift+% and it becomes 37.78%. The trickier part comes when you're dealing with negatives or zeros. I was working on a margin analysis last year where a product line went from a negative value to a positive one. The formula gave me a result, but it was completely meaningless in context. Percentage increase from a negative base is not a useful metric. I had to add a conditional check to display N/A instead when the old value was zero or negative, which meant wrapping the whole thing in an IF statement like =IF(A2

=0,"N/A",(B2-A2)/A2). For bulk calculations across thousands of rows, dragging the fill handle works but can be slow on larger datasets. Instead, select your entire column range, type the formula once, and press Ctrl+Enter. This fills every selected cell simultaneously and saves time without the lag you get from dragging across long columns.

Another thing that trips people up is relative versus absolute references. If you're calculating percentage changes against a fixed base year in cell A1, you need to lock that reference with dollar signs: = (B2-$A$1)/$A$1. Without the dollar signs, every row down shifts the reference and your numbers go sideways. You can also use the PERCENTCHANGE custom function approach if you do this repeatedly, but honestly the manual formula with proper referencing covers 99% of real-world scenarios. Just make sure your source data is clean before applying the formula. One stray text entry or blank cell in the denominator column will throw the entire range into error mode. Download reference sheet: A simple template with these formulas pre-set is available at https://example.com/percentage-increase-template.xlsx. It includes the conditional logic for handling zeros and negatives so you don't have to build that yourself.

The formula approach breaks down when you need to compare across multiple time periods or calculate compound growth rates. For those cases you'd want to use the CAGR function or build a chained growth model. But for straight year over year or period to period percentage change, the method above is what almost everyone ends up using anyway.