# GROWTH Excel Formula

One of the frequently used Microsoft program is Microsoft Excel. This application is used to gather and store vital information. Also, this is utilized to manipulate and display numerical facts. The program provides classification of data and the tools of analysis help users to accurately arrange the gathered facts and create graphs or charts through a spreadsheet. To easily utilize the program for calculation, you must have a complete knowledge and familiarity of the excel functions. This is for the reason that the program works on specified formulas. Every function of Excel has corresponding syntax to be used. This article talks about the excel function called GROWTH.

**What is GROWTH Function?**

The GROWTH function computes the possible exponential growth through a specified grouping of y-values and x-values. This function expands the curve to compute and analyze the additional y-values intended for the advance set of x-values.

**What is the GROWTH Function Syntax?**

Since Excel is a formula-based program, the right syntax to use in GROWTH function should be:

=GROWTH(known_y’s, known_x’s, new_x’s, const)

**Wherein the known arguments are:**

- known_y’s – the set of identified y-values that are utilized to predict and calculate the exponential growth.
- known_x’s – an optional set of arguments for x-values, that if ever provided, should contain the same length of a set of the known_y’s.
- new_x’s – these are the new set of x-values wherein the function computes the subsequent new y_values. But if this is omitted, the faction of [new_x’s] is believed to be similar to the identified [known_x’s] and this function computes the y-values that is found on the computed exponential growth curve.
- const – this is a discretionary logical argument that identifies the constant “b” which is included in the equation y = mx + b, which is required to be the same or equal to a value of 1.

**What are the Things to Ponder?**

In using the GROWTH function, there are some details that need to be considered to ensure that the program is used efficiently and they are as follows:

- If the desired answer is in range form, the formula to be keyed in should be in range form too after selecting the right number of cells.
- Once you enter the constant range for known_x’s argument, use commas to separate the values in similar row and use semicolons to split rows.

**How GROWTH Function Works?**

For a better understanding of the function, it is important to check and study an example to see how it’s being used. Below are the procedures on how to use the function:

In a blank worksheet, type in the following values from cell A1 to cell A6, the given values are for the known_x’s argument:

- 11
- 12
- 13
- 14
- 15
- 16

**Then key in also the following values from cell B1 to cell B6. The specified values are for the known_y’s arguments:**

- 33,100
- 47, 300
- 69, 000
- 102, 000
- 150, 000
- 220, 000

**Type in the following values from cell C1 to cell C2, the values is for the new_x’s argument:**

- 17
- 18

**Do the following procedures to compute exponential GROWTH in Microsoft Excel:**

- Type in “=GROWTH(‘
- Type in comma.
- Select the range of cells that corresponds to the values of “known_y’s”
- Type in comma.
- Select the range of cells that corresponds to the values of “known_x’s”
- Select the range of cells that contains the value of “new_x’s”.
- Type in comma.
- Click for the cell containing the value for the constant.
- Type in a “closing parenthesis” and then press enter key.
- The answer for this is 320196.7

### Further readings

## Post comment

## Categories

## Recent Posts

- How to Use the MS Excel Keyboard Shortcuts
- How to Locate Duplicate Records Quickly By Using Conditional Formatting in MS Excel
- How to Use PasteSpecial – Procedures for Microsoft Excel 2003 and Microsoft Excel 2007
- How to Sort using an AutoFilter – Understanding and Learning the Feature
- How to Base a Chart Off of Auto Filtered Records
- How to Use IF IsError Together?
- How to Use Custom Views
- How to Create Pivt Table
- How to Manipulate PivotTable after It has Been Created
- How to Update the Data in a Pivot Table
- How to Create Dynamic Named Ranges
- How to Use an Array
- How to Embed 8 If Statements into 1
- How to Edit a Recorded Macro?
- How to Record a Macro