GROWTH Function
Returns values along an exponential (compound-growth) trend.
Category
Statistical
Available in
All versions; spills in Microsoft 365 and Excel 2021+ (older versions: select the output cells and press Ctrl+Shift+Enter)
Returns
A number or an array
Overview
GROWTH fits an exponential curve, y = b × mˣ, and returns its values for new x values. Use it when something grows by a roughly constant percentage each period — subscribers, users or compounding revenue — rather than by a constant amount.
It's the curved counterpart of TREND; LOGEST returns the curve's m and b.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| known_y's | Yes | The y values; all must be greater than 0. |
| known_x's | No | The x values. If left out, 1, 2, 3 … is used. |
| new_x's | No | The x values to predict for. If left out, the known x's are used. |
| const | No | TRUE or omitted calculates b; FALSE forces b to 1. |
Examples
Example 1 — Subscribers for the next two months
Subscribers have been growing by about 10% a month. GROWTH compounds; TREND adds a fixed amount.
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Month | Subscribers | Month | GROWTH | TREND | |
| 2 | 1 | 1000 | 7 | 1804.95 | 1741.33 | |
| 3 | 2 | 1120 | 8 | 1988.65 | 1866.48 | |
| 4 | 3 | 1230 | ||||
| 5 | 4 | 1350 | ||||
| 6 | 5 | 1490 | ||||
| 7 | 6 | 1630 |
The gap widens every month: compound growth pulls away from a straight line.
Common mistakes
- #NUM! A known y is zero or negative — an exponential curve can't pass through it.
- #SPILL! Cells below the formula aren't empty.
- Growth doesn't last forever. Extrapolating a compound rate far ahead quickly gives unrealistic numbers.
Notes

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.