GROWTH

Definition: GROWTH is a function that predicts a future value using exponential regression.

Syntax: =GROWTH(known_y’s, [known_x’s], [new_x’s], [const])

Situation: This formula is suitable when you need to predict a future value using exponential regression.

Example: If you have a set of known x and y values, and want to predict the y value for a new x value of 10, the formula =GROWTH(A1:A10, B1:B10, 10) can be used.