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

Want to practice GROWTH in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

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

=GROWTH(known_y's, [known_x's], [new_x's], [const])

Arguments

ArgumentRequired?What it does
known_y'sYesThe y values; all must be greater than 0.
known_x'sNoThe x values. If left out, 1, 2, 3 … is used.
new_x'sNoThe x values to predict for. If left out, the known x's are used.
constNoTRUE 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.

E2fx=GROWTH(B2:B7,A2:A7,D2:D3)
ABCDEF
1MonthSubscribersMonthGROWTHTREND
21100071804.951741.33
32112081988.651866.48
431230
541350
651490
761630
=GROWTH(B2:B7,A2:A7,D2:D3) Explain

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

Kyle Stott

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.