Google Sheets Growth Percentage Formula: How It Works and Examples

To calculate growth percentage in Google Sheets, subtract the earlier value from the later value, divide by the earlier value, and format the result as a percentage. If the earlier value is in A2 and the later value is in B2, enter =(B2-A2)/A2 in another cell.

The basic growth percentage formula

Percentage growth measures how much a value changed relative to where it started. The earlier value is the baseline, so it belongs in the denominator. The calculation is often written as (new value − old value) ÷ old value. In a spreadsheet, each reference points to the cell holding one of those values.

With the earlier value in A2 and the later value in B2, enter =(B2-A2)/A2. The equivalent shorter form is =B2/A2-1. Both formulas return the same result when A2 is not zero. The first makes the subtraction step more visible; the second compares the later value with the earlier value as a ratio, then removes the original 100%.

The result is a decimal until you format it as a percentage. For example, 0.25 represents 25% growth. Google Sheets can display the same underlying value as 0.25, 25%, or 25.0%, depending on the number format you choose. The formula calculates the change; formatting controls how that result appears.

A worked example with real numbers

Suppose weekly sign-ups increased from 80 in one week to 100 in the next. The absolute increase is 20 sign-ups, but the percentage growth compares that increase with the original 80. Dividing 20 by 80 gives 0.25, or 25%.

With 80 in A2 as the earlier count and 100 in B2 as the later count, enter =(B2-A2)/A2 in C2. The result is 0.25, which displays as 25% after percentage formatting. The arithmetic is (100 − 80) ÷ 80 = 20 ÷ 80 = 0.25.

Growth can also be negative. If a value falls from 120 to 90, the change is −30, and −30 divided by 120 is −0.25. With 120 in A3 as the earlier value and 90 in B3 as the later value, enter =(B3-A3)/A3. The result is −25%, meaning the value declined by one quarter of its starting amount. A negative percentage is not an error by itself; it indicates a decrease.

How to calculate growth down a column

For a time series, put dates in column A and the corresponding measurements in column B, ordered from earliest to latest. The first row has no earlier value within the list, so its growth cell can remain empty. Starting with the second measurement, compare each row with the row immediately above it.

With the first measurement in B2 and the next measurement in B3, enter =(B3-B2)/B2 in C3. If B2 is 80 and B3 is 100, C3 returns 25%. To calculate the next period, fill the formula down: the row references adjust to compare B4 with B3, then B5 with B4, and so on.

In Google Sheets, select the cell containing the formula and drag its small blue fill handle down the column, or copy and paste it into the rows below. Relative references such as B3 and B2 shift as the formula moves. That is usually what you want for consecutive-period growth. If you need a reference to stay fixed while filling a formula, add dollar signs to make it absolute, such as $B$2; ordinary period-to-period comparisons generally do not need this.

Check that the dates are in chronological order and that each row represents the intended interval. A missing month or a repeated date can make a mathematically correct comparison misleading. The formula only compares the values in the two referenced cells; it does not check whether the periods are equally spaced.

What the percentage means—and what it does not

Growth percentage is a relative change, not the raw amount of change. An increase of 20 units from 80 is 25%, while an increase of 20 from 200 is 10%. Both changes add the same number of units, but their starting points differ. This is why percentage growth is useful when comparing changes across products, teams, or periods with different baselines.

It is also important to identify the baseline consistently. A value rising from 50 to 60 is 20% growth because the increase of 10 is divided by 50. Reversing the comparison, from 60 down to 50, is a decrease of about 16.7%, not 20%, because the decrease is divided by 60. The up and down percentages differ because each uses a different starting value.

A percentage change alone does not explain why a value changed, whether the difference is meaningful, or how it will behave in the future. For instance, a small starting count can produce a large percentage increase from a modest numerical gain. When presenting results, consider showing the original values alongside the percentage so readers can see both scale and relative change.

Zero, blank, and negative starting values

If the earlier value is zero, the standard formula attempts to divide by zero. There is no finite percentage change from a zero baseline: moving from zero to 10 is an increase of 10 units, but it cannot be expressed as a percentage of zero. Google Sheets will show a division error unless you handle that case. Do not label a zero-baseline change as 0% growth; that would suggest no change occurred.

With the earlier value in A2 and the later value in B2, use =IF(A2=0,"",(B2-A2)/A2) if you want the result cell to stay blank when the baseline is zero. This returns a blank for a zero starting value and calculates the ordinary percentage otherwise. A blank is a presentation choice, not a mathematical growth rate. You could instead display a note such as “N/A” by replacing the empty text argument with that label; such a text result will not behave like a number in later calculations.

A blank starting cell can also be treated like zero in arithmetic, so consider whether blank data should mean “no value recorded” rather than a true zero. If missing data should remain visibly distinct, check for blanks separately before calculating. Negative baselines need care too. For example, moving from −20 to −10 is an improvement in many contexts, but the standard calculation returns −50% because the change of 10 is divided by −20. For values that can be negative—such as profit or temperature—explain the chosen convention or report the absolute change as well. Percentage growth is easiest to interpret when the starting value is positive.

Format the result as a percentage

After entering the formula, select the result cell or range and choose Format > Number > Percent in Google Sheets. The displayed value changes to a percentage without changing the underlying calculation. For example, a stored result of 0.25 displays as 25%.

Use the increase- or decrease-decimal-place controls in the toolbar when more or fewer digits are useful. With zero decimal places, a result such as 12.345% may display rounded as 12%; with two places it can display as 12.35%. Rounding the display does not necessarily round the stored value, so later formulas generally continue to use the underlying precision.

Do not multiply by 100 and then also apply percentage formatting. With the earlier value in A2 and the later value in B2, =(B2-A2)/A2*100 returns 25 for the example 80 to 100. If that 25 is formatted as a percentage, Sheets displays 2500%. Use either the regular decimal formula with percentage formatting, or a result multiplied by 100 that you leave as a regular number; the first approach is usually clearer.

Choose the right comparison for your question

Period-to-period growth and overall growth answer different questions. A column of adjacent comparisons shows how much each interval changed from the one immediately before it. Overall growth compares the final value with the initial value, regardless of the intermediate ups and downs. If a metric rises, falls, and then rises again, the last period’s growth does not describe the total change since the beginning.

With the starting value in B2 and the ending value in B10, enter =(B10-B2)/B2 to calculate total growth across that span. For example, if B2 is 80 and B10 is 120, the result is 50%. This does not mean the value grew by 50% in every period; it means the ending value is 50% higher than the starting value.

For a multi-year comparison, an annualized rate can express the constant yearly rate that would connect a positive starting value to a positive ending value. It is not the same as simply dividing total growth by the number of years. With the starting value in B2, ending value in B3, and elapsed years in C2, enter =(B3/B2)^(1/C2)-1. If the values are 100 and 133.1 over three years, the result is 10% per year because 100 multiplied by 1.1 three times equals 133.1. This calculation assumes the elapsed time is correctly entered in years and is generally unsuitable for zero or negative values.

Common mistakes and quick checks

Using the later value as the denominator: dividing the change by the new value gives a different measure. For growth from 80 to 100, the standard calculation divides 20 by 80, not by 100.
Reversing the subtraction: the formula should subtract earlier from later. Reversing it changes the sign and makes an increase look like a decline.
Confusing a decimal with a percent: 0.08 is 8% when formatted as a percentage. If the display seems 100 times too large, check whether the formula already multiplies by 100.
Ignoring a zero baseline: division by zero is undefined. Decide whether to show a blank, a label, or a separate absolute change instead of claiming a percentage.
Comparing the wrong rows: confirm that the old and new values belong to the intended periods and that dates are sorted correctly.

If a result shows an error, inspect the denominator first, then check whether the input cells contain numbers rather than text that only looks numeric. Also verify that the formula references the intended cells. In Google Sheets, formulas shown here use commas where a function has arguments; spreadsheet locale settings can require semicolons instead. Google Sheets and Excel use the same basic arithmetic formula, although menu names and interface details differ between the applications.

Frequently Asked Questions

What is the formula for percentage growth in Google Sheets?
Subtract the earlier value from the later value and divide by the earlier value. If the earlier value is A2 and the later value is B2, use =(B2-A2)/A2, then format the result as a percentage.

How do I calculate percentage increase between two numbers?
Use the same growth formula: (new number − old number) ÷ old number. For example, an increase from 40 to 50 is 25%, because the change of 10 is one quarter of 40.

How do I show a negative growth percentage?
Keep the earlier value first in the denominator and subtract it from the later value. If the later value is smaller, the result will be negative; format the cell as a percentage to display the decline clearly.

Why does my Google Sheets growth formula show an error?
A common cause is a zero starting value, which makes the formula divide by zero. Check that the baseline is not zero and that the referenced cells contain the intended numeric values.

Should I multiply the formula by 100?
Usually, no. The standard formula returns a decimal that Google Sheets displays as a percentage when you choose Format > Number > Percent. Multiplying by 100 as well would make percentage formatting show a result 100 times too large.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.