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.