Functions
GROWTH
Returns values along an exponential trend
Try it
When to use it
When should I use GROWTH?
Use GROWTH to project future values along an exponential trend fitted to known data points, suitable for modeling compound-growth scenarios.
Used in
Syntax
GROWTH(known_y, [known_x], [new_x], [const])Examples
=GROWTH({2,4,8,16,32}) // => 2.0000000000000013
=GROWTH({2,4,8,16},{1,2,3,4}) // => 2.0000000000000004
=GROWTH({2,4,8,16},{1,2,3,4},{5}) // => 31.99999999999998