Author: Oscar Cronquist Article last updated on September 11, 2018

The GROWTH function returns estimated exponential growth based on given data. It calculates the y-values for new x-values based on existing x and y-values, see the following formula and the image above.

Array formula in cell B15:B16:

=GROWTH(B3:B13,C3:C13,C15:C16)

The GROWTH function allows you also to fit exponential values to existing x and y-values.

Array formula in cell D3:D13:

=GROWTH(B3:B13,C3:C13)

To enter an array formula select cell range D3:D13, type the formula and then press and hold CTRL + SHIFT simultaneously, now press Enter once. Release all keys.

The formula bar now shows the formula with a beginning and ending curly bracket telling you that you entered the formula successfully.

Don't enter the curly brackets yourself, they appear automatically.

Excel Function Syntax

GROWTH(known_y's, [known_x's], [new_x's], [const])

Arguments

known_y's Required.  Y-values you want to use.
[known_x's] Optional. X-values you want to use.
[new_x's] Optional. The GROWTH function uses these values to calculate the corresponding y-values.
[const] Optional.  Boolean value that determines whether to force the constant b to be 1.
TRUE - b is calculated. (Default value).
FALSE - b is equal to 1 and m-values are adjusted.

Comments

The relationship used is y=b*m^x if [const] is TRUE and y=m^x if [const] is FALSE.