GROWTH Function in Google Sheets

Calculate exponential growth trends using the GROWTH function.

GROWTH Function

The GROWTH function in Google Sheets calculates exponential growth trends based on known and new data.

Syntax

GROWTH(known_data_y, [known_data_x], [new_data_x], [b])
  • known_data_y: The dependent data to analyze.
  • known_data_x: The independent data associated with known_data_y (optional).
  • new_data_x: New independent data to predict values for (optional).
  • b: A logical value to force b to 0 (optional).

Examples

  1. Basic Example

Calculate the growth trend of data in A1:A10:

=GROWTH(A1:A10)

Notes

  • Useful for forecasting and trend analysis.
  • TREND: Calculate linear trends.