Excel Functions Tutorials

- Excel Formulas Cheatsheet
- Excel
- Financial Functions in Excel
- Logical Functions in Excel
- TEXT Functions in Excel
- Concatenate Excel Function
- RIGHT Function in Excel
- LEN in Excel
- LEFT Function in Excel
- Search Function in Excel
- TEXT Function in Excel
- PROPER in Excel
- MID in Excel
- Trim in Excel
- CLEAN Excel Function
- EXACT Excel Function
- REPT Function in Excel
- CODE Excel Function
- FIND Function in Excel
- VALUE Function in Excel
- Char Function In Excel
- Substitute Function in Excel
- Substring in Excel

- Lookup Reference in Excel
- Address Function in Excel
- Choose Function in Excel
- Column Function in Excel
- Columns Function in Excel
- REPLACE Function in Excel
- GetPivotData in Excel
- HLOOKUP in Excel
- Hyperlink Excel Function
- INDIRECT Function in Excel
- LOOKUP Excel Function
- Match Excel Function
- VLOOKUP Excel Function
- INDEX Excel Function
- VLOOKUP vs HLOOKUP
- TRANSPOSE Excel Function
- Row Function in Excel
- OFFSET Excel Function
- VLOOKUP with Multiple Criteria
- IFERROR with VLOOKUP in Excel
- Fixing VLOOKUP Errors
- Alternatives to Vlookup

- Maths Functions in Excel
- POWER Function in Excel
- EVEN Function in Excel
- ODD Function in Excel
- ABS Function in Excel
- SUM Function in Excel
- SUMPRODUCT Function in Excel
- SUBTOTAL Excel Function
- ROUND in Excel
- AGGREGATE Excel Function
- PRODUCT Excel Function
- RAND Excel Function
- LOG Excel Function
- EXPONENTIAL Excel Function
- SUMIF in Excel
- TAN Excel Function
- CEILING Excel Function
- LN Excel Function
- SIGN Excel Function
- COS Excel Function
- FLOOR Function in Excel
- SIN Excel Function
- ROUNDDOWN Excel Function
- ROUNDUP Function in Excel
- DSUM
- COMBIN Excel Function
- INT Excel Function (Integer)
- TANH in Excel

- Date and Time Function in Excel
- Statistical Function in Excel
- AVERAGE Excel Function
- CORREL Excel Function
- COUNT Excel Function
- COUNTIF Excel Function
- FREQUENCY Excel Function
- MAX Excel Function
- MEDIAN Excel Function
- GROWTH Excel Function
- SLOPE Function in Excel
- TREND Function in Excel
- SMALL Function in Excel
- MODE Excel Function
- LARGE Excel Function
- PERCENTILE Excel Function
- LINEST Excel Function
- T-TEST in Excel
- QUARTILE Excel Function
- FORECAST Excel Function
- MIN in Excel
- Standard Deviation in Excel
- COUNTIF with Multiple Criteria
- Mean vs Median
- NORM.S.INV Function in Excel
- NORMDIST in Excel
- Variance vs Standard Deviation

- Information Functions in Excel
- Excel Charts
- Column Chart in excel
- Stacked Column Chart
- Pie Chart in Excel
- Area Chart in Excel
- Stacked Chart in Excel (Column, Bar & 100% Stacked)
- Histogram Excel Chart
- Waterfall Chart in Excel
- Pareto Chart in Excel
- Bubble Chart in Excel
- Gantt Chart in Excel
- Radar Chart in Excel (Spider Chart)
- Clustered Bar Chart in Excel
- Clustered Column Chart in Excel
- Dynamic Chart in Excel

- Excel Tools
- Watch Window in Excel
- List Box in Excel VBA
- Conditional Formatting in Excel
- Data Table in Excel
- Data Validation Excel
- Paste Special in Excel (With Top 10 Shortcuts)
- One Variable Data Table in Excel
- Two-Variable Data Table in Excel
- Scenario Manager in Excel
- Solver in Excel
- Name Range in Excel
- Dynamic Named Range in Excel
- Sort Data in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Auto Format Excel
- Track Changes in Excel
- Text to Columns in Excel
- Merge Cells in Excel
- Lock Cells in Excel
- Scroll Bars in Excel
- Spell Check in Excel
- Filters in Excel
- Auto Filter In Excel
- Advanced Filter in Excel
- Recording Macros in Excel
- Add-Ins in excel
- Excel Fill Handle
- AutoFill in Excel
- Excel Tables
- Radio Button in Excel
- Combo Box in Excel and VBA
- Checkbox in Excel

- Excel Tips
- How to Unhide Columns in Excel?
- Convert Date to Text in Excel
- Top 20 Keyboard Shortcuts in Excel
- Convert Numbers to Text in Excel
- Show Formula in Excel
- Absolute Reference in Excel
- Relative References in Excel
- Superscript in Excel
- Subscript in Excel
- Formula Errors in Excel
- Convert Text to Numbers in Excel
- Insert Multiple Rows in Excel
- Remove Blank Rows in Excel
- Highlight Every Other Row in Excel
- External Links in Excel
- Insert Hyperlinks in Excel
- Remove Hyperlinks in Excel
- Combine Cells in Excel
- Remove Duplicates in Excel
- Random Numbers in Excel
- Drop Down List in Excel
- Refresh Pivot Table in Excel
- Column Sort in Excel
- Hiding a Column in Excel
- Count Unique Values in Excel
- CAGR Formula in Excel
- Equations in Excel
- How to Delete Pivot Table?
- Excel Subtraction Formula
- Excel Extensions
- Hide Formula in Excel
- Numbering in Excel
- Auto Numbering in Excel
- Row Limit in Excel
- Delete Row Shortcut in Excel
- Arrays in Excel VBA
- Array Formulas in Excel
- Dynamic Tables in Excel
- Convert Columns to Rows in Excel
- Formatting in Excel
- Print Comments in Excel
- Excel vs Google Sheets

**Growth Excel Function (Table of Contents)**

## Growth Function in Excel

Exponential Growth function in Excel is a Statistical Function that returns the predictive exponential growth for a given set of data. For a given new value of x it returns the predicted value of y. Growth formula in Excel helps in financial and statistical analysis, it helps to predict revenue targets, sales. It is also used in regression analysis in excel, wherever the growth is calculated exponentially. This function fits an exponential curve to the data and returns the dependent value of y for the new value of x specified.

### GROWTH Formula in Excel

Below is the GROWTH Formula in Excel

### Exponential Growth Curve

For GROWTH Formula in Excel, **y =b* m^x **represents an exponential curve where the value of y depends upon the value x, m is the base with exponent x and b is a constant value.

**For a given relation y =b*m^x**

**Known_y’s:** is a set of y-values in the data set. It is a required argument.

**Known_x’s: **is a set of x-values in the data set. The range value for known_x’s should be the same as known_y’s values. It is an optional argument. If known_x’s is omitted, it is assumed to be the array (1,2,3,…) that is the same size as known_y’s.

**New_x’s: **is the new value of x for which we want to calculate the predictive corresponding value. If we omit this value, the new value of x the function that the value as the same value of known x’s and based on that value it returns the value of y. New_x’s must include a column (or row) for each independent variable, just as known_x’s does. So, if known_y’s is in a single column, known_x’s and new_x’s must have the same number of columns. If known_y’s is in a single row, known_x’s and new_x’s must have the same number of rows. If new_x’s is omitted, it is assumed to be the same as known_x’s.

If both known_x’s and new_x’s are omitted, they are assumed to be the array (1, 2, 3,…) that is the same size as known_y’s.

**Const: **is also an optional argument that tells whether the constant b for equation y= b* m^x be equal to 1. It the constant value is true or is omitted, then the value of b is calculated normally, else if the constant value is false, and the value of b is set equal to 1 and the values of m are adjusted such that we have the relation y = m^x.

The Exponential growth formula is very helpful to calculate the estimated growth when a growth occurs exponentially. For example, in biology, where a microorganism increases exponentially. Human population also grows exponentially. The stock prices and other financial figures may follow the exponential growth, so in these scenarios, one can use the Exponential growth function to depict the estimated growth.

**How to Use GROWTH Function in Excel?**

GROWTH in excel is very simple and easy to use. Let understand the working of GROWTH in excel by some examples.

### GROWTH in Excel Example #1

We have a given data sample with given values of X and Y and we want to calculate the Growth using the Growth formula in Excel.

So, the GROWTH formula in Excel that we will use is

**=GROWTH(B2:B7,A2:A7)**

**Output:**

### GROWTH in Excel Example #2

Suppose there a company that has revenue for the previous ten years. Column A has the years mentioned and column B contains the revenue for each given year. We want to calculate the revenue for the upcoming year. Based on the previously given data we want to calculate the estimated revenue for the year 2019.

To predict the revenue for the year 2019, we will be using the GROWTH formula in excel. In this case, the new X value is the upcoming year which is 2019

The GROWTH Formula in Excel that we will be using will be

**=GROWTH(B3:B12,A3:A12,A13)**

**Output:**

So, in the year 2019, the company most probably will generate revenue around **$291181.03**

### GROWTH in Excel Example #3

Suppose in a lab we have an organic solution that contains bacteria that are growing exponentially in the solution. They are increasing with the increase of time given in seconds. We have the sample data for number of bacteria with given time periods in seconds. We need to estimate the bacteria growth after 150 seconds.

Column A contains the time values in seconds and the column B contains the number of bacteria that are multiplying exponentially.

In order to estimate the increase or growth in the product over a certain period of time we will using the Exponential GROWTH function.

We will select the range of known y values which is number of bacteria growing with time and known x values which is the time period given in seconds and the new x values is 150 second for which we need to calculate the estimated increase in the number of bacteria.

The GROWTH formula in Excel that we will be using is:

**=ROUND(GROWTH(B2:B13,A2:A13,A14),0)**

**Output:**

The total estimated number of bacteria in the solution after 150 seconds will be approximately** 393436223.**

**Things to Remember About GROWTH Function in Excel**

- We can use the Exponential Growth function as an array when more than one new value of y is computed. In that case, the function is entered as an array formula by using the Crtl+ Shift+ Enter
- The Growth function in Excel throws #REF! error when the known_x’s array doesn’t have the same length equal to known_y’s array.
- The Growth function in Excel throws #NUM! error if any value of known_y’s array is less than or equal to zero.
- The Growth function in Excel throws #VALUE! error if any of known_y’s, known_x’s or new x value is not numeric.
- While using the Exponential Growth function in graphs we can often use the exponential option from the graph trend line option.

You can download this GROWTH in Excel template here – GROWTH Function Excel Template

### Recommended Articles

This has been a guide to GROWTH Function in Excel. Here we discuss the GROWTH Formula and how to use GROWTH in excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –

## Leave a Reply