# MS Excel: GROWTH Function (WS)

This Excel tutorial explains how to use the Excel GROWTH function with syntax and examples.

## Description

The Microsoft Excel GROWTH function returns the predicted exponential growth based on existing values provided.

## Syntax

The syntax for the Microsoft Excel GROWTH function is:

`GROWTH( known_y_values, [known_x_values], [new_x_values], [constant] )`

### Parameters or Arguments

known_y_values is the known y-values used to predict the exponential growth.

known_x_values is optional. It is the known x-values used to predict the exponential growth. If this parameter is omitted, the GROWTH function uses {1,2,3,...} as the known_x_values parameter.

new_x_values is optional. It is the x-values that are used by the GROWTH function to return the corresponding y-values. If this parameter is omitted, the GROWTH function uses {1,2,3,...} as the new_x_values parameter.

constant is optional. It is either a TRUE or FALSE value. TRUE means that the constant b is calculated normally. FALSE means that the constant b is set to 1. If this parameter is omitted, the GROWTH function assumes a constant parameter of TRUE.

## Applies To

The GROWTH function can be used in the following versions of Microsoft Excel:

• Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

## Type of Excel Function

The GROWTH function can be used in Microsoft Excel as the following type of function:

• Worksheet function (WS)

## Example (as Worksheet Function)

Let's look at some Excel GROWTH function examples and explore how to use the GROWTH function as a worksheet function in Microsoft Excel:

Based on the spreadsheet above, the following Excel GROWTH examples would return:

```=GROWTH(B2:B6, A2:A6)
Result: 7.344380549

=GROWTH({4,5,6})
Result: 4.027307453

=GROWTH({4,5,6}, {10,20,30})
Result: 4.027307453

=GROWTH({4,5,6}, {10,20,30}, {15,30,45})
Result: 4.456948343

=GROWTH({4,5,6}, {10,20,30}, {15,30,45}, FALSE)
Result: 2.913437857```
Share: