GROWTH Function in Excel: Extend an Exponential Trend

⏱ 1 min readUpdated 28 September 2026

StatisticsLevel: ExpertAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Related functions

GROWTH is TREND for things that grow by a percentage — sign-ups, compounding balances — rather than by a fixed amount.

Syntax

=GROWTH(known_ys, [known_xs], [new_xs], [const])
Argument What it means
known_ys Must be positive.

Examples

Example 1

=GROWTH(C2:C13, A2:A13, A14:A16)

Next quarter of sign-ups at the current growth rate.

💡 Exponential forecasts explode quickly. Use them for a few periods, not five years.

TREND · LOGEST

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZPERCENTILE.INC Function in Excel: Value at a Percentile (e.g. 90th)Excel Functions A–ZPDURATION Function in Excel: Years Needed to Reach a TargetExcel Functions A–ZWEEKNUM Function in Excel: Week Number of the Year
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong