### Excel GROWTH Function

This Excel Tutorial demonstrates how to use the Excel GROWTH Function in Excel to return values based on exponential growth, with formula examples.

## GROWTH Function Description:

The GROWTH Function Calculates Y values based on exponential growth rate for given X values. The exponential growth rate is calculated using two data series.

## Formula Examples: Example Formula Result
1 =GROWTH(\$B\$5:\$B\$9,\$C\$5:\$C\$9,E5) 154.931721653676
2 =GROWTH(\$B\$5:\$B\$9,\$C\$5:\$C\$9,E6) 420.800468356409
3 =GROWTH(\$B\$5:\$B\$9,\$C\$5:\$C\$9,E7) 1142.91013021072
4 =GROWTH(\$B\$5:\$B\$9,\$C\$5:\$C\$9,E8,F8) 1142.91013021072
5 =GROWTH(\$B\$5:\$B\$9,\$C\$5:\$C\$9,E9,F9) 370.988097684002

## Syntax and Arguments:

The Syntax for the GROWTH Formula is:

### Function Arguments ( Inputs ):

known_y’s – An array of known Y values.

known_x’s – An array of known X values.

new_x’s – An array of new X values that you want TREND to return corresponding Y values for.

const – OPTIONAL. Logical value indicating whether to calculate B (the intercept in y = mx + b) using the least squares method (TRUE Or Ommitted) or to manually set B = 0 (FALSE).

## GROWTH Examples in VBA

You can also use the GROWTH function in VBA. Type:
`application.worksheetfunction.growth(known_ys,known_x,new_x,const)`
For the function arguments (known_y’s, etc.), you can either enter them directly into the function, or define variables to use instead.

`=AND(`  