GROWTH
Returns values along an exponential trend
Syntax
GROWTH(known_y's, [known_x's], [new_x's], [const])
Parameters
- known_y's: Required. The set of y-values, a set of positive numbers
- known_x's: Optional. The set of x-values
- new_x's: Optional. New x-values for which GROWTH returns corresponding y-values
- const: Optional. A logical value: if TRUE (default), b is calculated normally; if FALSE, b is set equal to 1
Example
=GROWTH(A1:A10, B1:B10)