Percentage increase shows up everywhere. Sales reports. Salary reviews. Budget forecasts. The good news? Excel handles it with one simple formula, and once you learn the pattern, you'll spot it instantly.
Here's the core idea: percentage increase compares a new value to an older one, then expresses the gap as a portion of the original. If revenue jumped from $50,000 to $65,000, you want to know not just the $15,000 difference but how big that leap feels relative to where you started. That's the percentage growth story, and it matters because raw dollar amounts can hide trends. A $1,000 gain sounds great until you realize the starting value was $10 million.
This guide walks through every angle. The basic formula. Shortcuts using built-in functions. How to format cells so they don't show a confusing 0.25 when you wanted 25%. Common mistakes (negative starting values are a trap). And a few advanced tricks for tracking growth across multiple periods.
You'll also see practical examples drawn from real workplace scenarios: monthly sales tracking, year-over-year comparisons, salary raise calculations, and compound annual growth rate (CAGR) for long-term investments. Each example uses the same fundamental formula with small tweaks, so once you understand the core pattern, everything else clicks into place quickly.
By the end, you'll be calculating percentage increases faster than your coworker can open a calculator app, and you'll know how to spot when the formula is giving you a misleading result that needs adjustment.
Strip away the noise and the formula is short: =(New Value - Old Value) / Old Value. That's it. Excel does the rest once you format the cell as a percentage. This formula works in every version of Excel from 2003 through the latest Microsoft 365 release, plus Google Sheets, LibreOffice Calc, and Apple Numbers. The math is universal.
Say your old value sits in cell A1 and your new value in B1. Type this into C1: =(B1-A1)/A1. Press Enter. You'll see something like 0.3 or maybe 1.45. Don't panic. That decimal is correct, you just need to tell Excel to display it as a percentage.
Click the cell, then hit the % button on the Home ribbon. Suddenly 0.3 becomes 30%. The math hasn't changed, only the way Excel shows it. This formatting step trips up beginners constantly, so burn it into memory: calculate first, format second. The formula bar will still show 0.3 even though the cell displays 30%, because Excel stores percentages as their decimal equivalent under the hood.
Want to skip the formatting step? Multiply the formula by 100: =(B1-A1)/A1*100. Now the cell shows 30 (without the % symbol). Some people prefer this approach for reports where the column header already says "% Change." Others avoid it because the resulting cell is just a regular number, which can cause confusion if it gets pasted somewhere expecting percentage formatting.
Whichever style you pick, stay consistent throughout a single workbook. Mixing formats is the fastest way to introduce subtle errors that take hours to track down later.
Quick Mental Check: If the new value is double the old value, your percentage increase should equal 100%. So $50 to $100 is a 100% increase, not 200%. A 200% increase would mean tripling. This catches a surprising number of formula errors during quick sanity checks, especially when you're dragging formulas across hundreds of rows.
Let's say you're tracking monthly sales. January closed at $42,000. February finished at $51,300. What's the percentage increase?
Drop the numbers into your spreadsheet. A2 holds 42000. B2 holds 51300. In C2, type =(B2-A2)/A2 and hit Enter. The cell shows 0.221428... Format it as a percentage with one decimal place and you get 22.1%. That's solid month-over-month growth, the kind that triggers congratulatory emails from the boss.
Now imagine you've got twelve months of data. You don't want to retype the formula twelve times. Click C2, grab the small green square in the bottom-right corner of the cell (the fill handle), and drag down. Excel copies the formula and adjusts the cell references automatically. Suddenly you have a full year of growth percentages in seconds. This is the kind of trick that separates Excel beginners from intermediate users.
One quick note about relative references. When you drag a formula down, Excel shifts both A2 and B2 to A3 and B3, then A4 and B4. This is usually what you want. But sometimes you need to compare every month against a fixed baseline (say, January). In that case, lock the reference with dollar signs: =(B2-$A$2)/$A$2. The dollar signs freeze A2 no matter where you drag.
You can also mix and match. =(B2-$A$2)/$A$2 locks the column and row of A2 but lets B2 shift normally. $A2 locks only the column. A$2 locks only the row. F4 toggles between these modes when your cursor is on a cell reference inside a formula, saving a lot of typing.
Type =(B1-A1)/A1 and format as percentage. Most flexible and transparent. Best for learning and for spreadsheets others will audit later. Produces clean decimal output that Excel converts to a percentage display automatically when you apply percentage formatting through the Home ribbon or the Ctrl+Shift+% keyboard shortcut.
Use =B1/A1-1 which gives the same result with fewer keystrokes. Good for quick checks and nesting inside other formulas like SUMPRODUCT, IFERROR, or array operations. Power users prefer this compact form because it composes elegantly with complex calculations involving multiple cells, ranges, or conditional logic statements.
Use =(B1-A1)/A1*100 to skip formatting. Returns a plain number like 25 instead of 25%. Useful when feeding the result into other math, exporting to CSV files, or building reports where percentage formatting would interfere with downstream processing in another tool. Pairs well with TEXT function for custom display strings.
The shortcut =B1/A1-1 looks weird but it's mathematically identical to the standard formula. Here's why: dividing the new value by the old value gives you the ratio. If revenue grew from 100 to 125, then 125/100 equals 1.25. Subtract 1 and you get 0.25, or 25%. The "1" represents the original value as 100% of itself.
Some Excel veterans prefer this form because it reads cleanly when chained with other operations. For instance, you might wrap it in IFERROR to handle blank cells: =IFERROR(B1/A1-1, 0). That prevents the dreaded #DIV/0! error when A1 is empty or zero. The shorter formula stays readable inside complex nested expressions where every character counts.
Which version should you use? Honestly, pick whichever feels natural. The longer form makes the logic explicit, which helps when someone else has to audit your spreadsheet six months later. The shortcut form saves keystrokes in personal workbooks where you just need answers fast.
There's also a hybrid approach: =(B1/A1)-1 with parentheses around the division. Functionally identical, but the visual grouping reminds you what's happening. New Excel users often find this version easier to read because the parentheses tell the eye to evaluate that piece first.
Use =(B1-A1)/A1 in any empty cell. Format the result as a percentage using the % button on the Home tab. This is the textbook approach and the one most tutorials teach first. It works in every version of Excel and translates directly to Google Sheets and other spreadsheet apps without any modification needed. Best when you're teaching the concept to others or building a workbook that auditors will review later. The explicit subtraction and division steps make the math transparent at a glance.
Use =B1/A1-1 for the same result with fewer characters. Useful when you're building complex formulas that need to nest percentage calculations inside other operations like SUMPRODUCT or IF statements. Power users tend to favor this version because it composes nicely with other functions. The shorter form also reduces visual clutter in dense financial models where dozens of formulas appear on screen at once and readability becomes critical for maintenance.
For ranges, drag the fill handle to copy your formula. Excel adjusts cell references automatically. Use $A$1 absolute references if you need a fixed baseline across all comparisons. The keyboard shortcut Ctrl+D fills the formula from the cell above into selected cells below, which is faster than dragging for long columns. For really large datasets, double-click the fill handle and Excel will auto-fill down to the bottom of your contiguous data range without any manual dragging.
Multiply by 100 in the formula: =(B1-A1)/A1*100. This returns a plain number that you can use in further calculations without worrying about whether the cell is formatted as percentage or general number. The trade-off is that the cell no longer carries semantic meaning as a percentage, which can confuse colleagues reading the file later. Good for export workflows where the receiving system expects raw numeric values rather than formatted percentage cells.
Here's where Excel users get burned. Percentage increase formulas behave strangely when the old value is negative. Imagine your business lost $5,000 in Q1 (so A1 = -5000) and earned $3,000 in Q2 (B1 = 3000). What's the "percentage increase"?
Plug it into the formula: =(3000-(-5000))/-5000 equals -160%. Negative 160%? That makes no intuitive sense. The company improved, but the formula reports a negative result. The issue is mathematical: dividing a positive number by a negative number flips the sign, even when the underlying change is clearly positive in the real world.
The fix is to use the absolute value of the denominator: =(B1-A1)/ABS(A1). Now the same numbers return 160%, which correctly shows the swing from loss to profit. Some financial analysts use this version exclusively. Others argue that percentage change loses meaning when you cross zero, and you should report the dollar change instead.
Either approach is defensible. Just pick one and be consistent. Mixing methods inside the same report creates confusion that's hard to debug later. If you're working with financial data that frequently swings between positive and negative (think trading P&L or struggling startup runways), consider adding a note column explaining how percentages are calculated. Transparency beats elegance when the math gets weird.
Some companies sidestep the whole problem by reporting dollar changes alongside percentages whenever values are small or negative. A line item showing "+$8,000 (+160%)" is harder to misinterpret than a percentage alone.
The percentage format button on the Home ribbon adds two decimal places by default in some Excel versions, zero in others. To control precision, right-click the cell, choose Format Cells, pick Percentage, and set the decimal places to whatever you need. One decimal place works well for most business reports. Zero decimals look cleaner in dashboards where space is tight.
Keyboard shortcut to apply percentage format: Ctrl + Shift + %. Hit it on a selected cell or range and Excel instantly switches to percentage display with zero decimals. To add decimals back, click the "Increase Decimal" button (looks like .00 with an arrow) on the Home tab. Or right-click and customize through Format Cells for exact precision.
Conditional formatting takes things further. You can highlight positive changes in green and negative ones in red automatically. Select your percentage column, go to Home > Conditional Formatting > Color Scales, and pick a red-yellow-green palette. Suddenly your spreadsheet tells a visual story without anyone reading the numbers. Executives love this kind of quick visual scanning during meetings.
For dashboards, consider showing the actual change alongside the percentage. A cell showing "+22.1% ($9,300)" gives readers both the relative and absolute picture. Use Excel's concatenation: =TEXT(C2,"+0.0%")&" ("&TEXT(B2-A2,"$#,##0")&")". It looks dense but the result reads cleanly.
Custom number formats let you control colors and conditional displays inline. The format string [Green]+0.0%;[Red]-0.0%;0.0% shows positive percentages in green with a plus sign, negative in red with a minus sign, and zero in default color. Apply through Format Cells > Custom and the cell becomes self-documenting.
Single-period growth is easy. Multi-period growth gets interesting. If sales grew 10% in year one and 20% in year two, the total isn't 30%. It's 32%, because the year-two growth compounds on the already-grown year-one base. This is the same math that makes long-term investing powerful, and the same math that makes credit card debt dangerous.
To find compound growth across multiple periods, multiply the growth factors. Year one factor is 1.10 (the original 100% plus 10% growth). Year two factor is 1.20. Multiply them: 1.10 × 1.20 = 1.32. Subtract 1 and you get 32% total growth.
In Excel, if your annual growth rates sit in B2:B5, calculate total compound growth with =PRODUCT(1+B2:B5)-1. Enter it as an array formula in older Excel versions (Ctrl+Shift+Enter) or as a regular formula in Excel 365. The PRODUCT function multiplies everything inside the range together in one step, saving you from typing out the chain manually.
For the compound annual growth rate (CAGR), use this formula: =(EndValue/StartValue)^(1/Years)-1. So if revenue went from $100K to $250K over 5 years, CAGR equals =(250000/100000)^(1/5)-1 = 20.1%. That means the business grew at an average compounded rate of 20.1% per year, smoothing out the bumpy reality of year-to-year fluctuations into a single clean number that investors love.
CAGR is the gold standard for comparing growth across different time periods or different investments. Two businesses might both report "500% growth," but if one took five years and the other took twenty, their CAGRs tell completely different stories. The CAGR formula is also embedded in many of Excel's financial functions, including RATE and IRR, so understanding it pays dividends across spreadsheet work.
The biggest mistake by far is confusing percentage point change with percentage change. If a survey approval rating went from 40% to 50%, that's a 10 percentage point increase but a 25% increase (because 10 divided by 40 is 25%). News headlines mix these up constantly. Don't do it in your spreadsheets. Politicians and pundits love exploiting the ambiguity to make changes sound bigger or smaller depending on their agenda.
Another classic error: subtracting in the wrong direction. The formula =(Old-New)/Old gives a negative result when values grow, which feels backward but is actually a valid "percentage decrease" calculation in disguise. Always put the newer value first when measuring increase. A quick way to remember: "new minus old" sounds right because chronologically newer comes after older.
Watch your formatting too. A cell showing "25" might mean 25% or it might mean 2,500% (if Excel interpreted the cell as a fraction). Click the cell and check the formula bar. If it shows 0.25 the format is correct. If it shows 25, the cell is in number format and 25 represents 2,500% when you click the % button. Always verify by checking the raw value in the formula bar before publishing reports.
Finally, beware of circular references when calculating percentages on totals. If your total row includes a percentage column that references the total, Excel throws a circular reference warning. Either calculate the total without the percentage row or use a separate cell for the grand total percentage. Iterative calculations can sometimes resolve these, but the cleaner fix is to restructure the spreadsheet so totals stand alone.
One more mistake worth flagging: averaging percentage changes. Adding up monthly growth rates and dividing by 12 gives you a wrong answer because it ignores compounding. Use the CAGR formula or geometric mean instead. GEOMEAN handles this in one step for Excel users who want the math handled automatically.
Percentage increase in Excel comes down to one formula: =(New-Old)/Old. Format as a percentage and you're done. Everything else, the negative values, the compound growth, the formatting tricks, builds on that foundation. Master the basics first, then add complexity as your needs grow.
The skills compound too. Once you've calculated percentage increase a few times, you'll start seeing applications everywhere. Year-over-year sales comparisons. Salary raises. Test score improvements. Inflation-adjusted budgets. Stock returns. The formula doesn't care what the numbers represent, only that you've identified which value came first and which came later.
If you're studying for an Excel certification or aptitude test, practice this formula until it's automatic. Many exam questions hide percentage calculations inside larger word problems, and the time you save on the mechanical math frees you up to think about the actual question. Run through the practice tests linked above to drill the muscle memory until the formula feels effortless.
One last tip: keep a personal "formula cheat sheet" tab in your workbooks. Paste the percentage increase formula at the top with a quick example. Future-you will thank past-you when a Friday afternoon deadline hits and your brain has gone blank on the basics. Some Excel power users keep entire libraries of named formulas they can call up by name, but a simple reference tab serves the same purpose for most situations.
Above all, sanity-check your results. Excel will happily compute wrong answers if you give it bad inputs. A quick mental estimate ("sales doubled so growth should be around 100%") catches most formula errors before they reach the executive team. Build that habit and your spreadsheet credibility will outshine colleagues who blindly trust the math.