EDUCBA

EDUCBA

MENUMENU
  • Blog
  • All Courses
  • All in One Bundle
  • Login
Home Excel Excel Resources Statistical Functions in Excel Excel GROWTH Formula

Excel GROWTH Formula

By Madhuri ThakurMadhuri Thakur

GROWTH Formula in Excel

Excel GROWTH Formula (Table of Contents)

  • GROWTH Formula in Excel
  • How to Calculate GROWTH in Excel using Formula?

GROWTH Formula in Excel

Growth formula in Excel is a statistical function. Growth formula returns the predicted exponential growth rate based on existing values given in excel. It is found under Formulas<More Functions<Statistical<Growth. It is a worksheet function. Growth formula is available in all versions of Excel. This function is used for statistical and financial analysis. It helps in predicting and forecasting revenues and sales targets of companies. Growth formula is also used in Regression analysis in Excel.

Start Your Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

In simple terms, the growth function calculates Y values on the basis of an exponential growth rate of given X values.

Below is the Formula for GROWTH in Excel :

GROWTH Formula

The GROWTH Formula has the below arguments.

  • known_y’s: This is a set of known Y’s values. This is a required argument. These values are used to estimate growth.
  • known_x’s: This is the provided set of X’s values. It is also used to estimate exponential growth. It’s an optional argument, and in its absence, it is assumed that the array is of the same size as that of known_Y’s
  • New_x ’s: It is an optional argument. It is the value for which we use Growth function to calculate the predictive corresponding y-values. But if this is omitted, the values of new_x’s are assumed to be the same known_x’s values. This will return the y values on exponential growth curve*

*Exponential Growth Curve in excel:

For Growth formula, Y = b*m^X

It represents an exponential curve in which the value of Y depends upon the value of X, m is base with X as its exponent, and b are constant.

  • Const: It is also an optional argument. It can be True or false. When it is True, b is calculated. When this is False, then b is taken as 1; when this argument is not given, it is assumed as True and is calculated normally.

This is a very helpful function to estimate or forecast growth that occurs exponentially.

How to Calculate GROWTH in Excel using Formula?

It is very simple and easy. Let’s understand how to calculate GROWTH in excel with some examples.

You can download this GROWTH Formula Excel Template here – GROWTH Formula Excel Template

Example #1

We have a data table wherein we have Period as known_x’s and Actual as known_y’s. The data is in the table below:

Example 1

We will write the formula as below:

Calculate GROWTH Example 1

Now we will press the Enter key to see the estimated growth.

GROWTH Formula Example 1-3

Example #2

We have sample data that shows months and their corresponding revenues. We will now estimate the revenue for the month of December (12) using the Growth formula in excel.

Example 2

We will write the formula as below:

We will input cell B2 to B12 as known _y’s, A2:A12 as known_x’s and A13 as new_x’s.

Calculate GROWTH Example 2

Press the Enter key to see the result.

GROWTH Formula Example 2-3

So the estimated revenue for the 12 months is $65,014.97.

Example #3

Suppose we wish to know whether a certain sales figure can be achieved for the coming financial year. So we want to achieve sales of $12 million.

We have a sample data table:

Example 3

  • Here Known_y’s are the sales values given.
  • Known_x ’s are the year for which we have sales values.
  • New_x’s is the year for which we will calculate the value. So the new_x’s will be cell A11 (for the year 2019).

We will write the formula:

Calculate GROWTH Example 3

The output will be :

GROWTH Formula Example 3-3

Hence, in the year 2019, most probably, the sales will be above the estimated 12 million.

Example #4

Taking the above formula, if we want to know the estimated sales for the year 2019, 2020 and the year 2021.

Example 4

Now we will write the formula:

Here the known_y’s re cells B2: B10, known_x’s are the years for which we have sales data. Here it will be A2: A10. Now the new_x’s will be from cells A11 to A13.

Calculate GROWTH Example 4

We will now press CTRL+SHIFT+ENTER to execute it as an array function. Hence you will see the curly brackets.

GROWTH Formula Example 4-3

We now have estimated sales for the year 2019= $1,499,186.53, year 2020 =$2,035,556.33 and year 2021 = $2,763,825.23

Example #5

To make things more clear, let’s take another example.

We have year wise revenue data of a company, and we want to forecast the revenue for the current year.

Example 5

We will now write the formula in cell B6:

Calculate GROWTH Example 5

Press the Enter key to get the output.

GROWTH Formula Example 5-3

The estimated revenue for the year 2019 will be $1,886,637.22.

Example #6

We will now look into an example of exponential growth. We have a sample data table.

Example 6

We will now write the formula as below:

Here known_y are cells B2:B10, known_x’s are cells A2:A10,new_x’s are cells D2:D10 and const are TRUE (till E8). We will input the cell ranges and will lock them by pressing F4.

GROWTH Formula Example 6-2

Once we have written the formula, we will press CTRL+SHIFT+ENTER to execute the array.

GROWTH Formula Example 6-3

Now we will write the formula for the remaining years where const is False.

GROWTH Formula Example 6-4

Press the CTRL+SHIFT+ENTER key simultaneously to get the output.

GROWTH Formula Example 6-5

Things to Remember

While using the excel growth formula, we have to be careful while writing the formula correctly. If we input the wrong syntax, we will not get the correct result. It would rather give some errors. Some of which are mentioned below. Hence keep the below-mentioned points in mind while using the function.

  • While using the Growth formula, you may get the #REF! error. This error will show up when the length of known_x’s array isn’t of the same length of known_y’s array.
  • The #NUM! error will occur if any value of known_y’s array is less than or equal to zero.
  • The #VALUE! An error occurs when known_y’s, known_x’s or new_ x’s value is not numeric or a text.
  • In growth function graphs, we often create a scatter chart of the data rather than a line. We use the exponential option from the graph trend line option.
  • The exponential Growth function is used as an array formula when multiple new values of y are to be calculated. So an array formula is then executed by using the Crtl+ Shift+ Enter and not Enter.

Recommended Articles

This has been a guide to GROWTH Formula in Excel. Here we discuss How to calculate GROWTH in Excel along with practical examples and a downloadable excel template. You can also go through our other suggested articles –

  1. Excel Percentage Difference
  2. MATCH Function in Excel
  3. PROPER in Excel
  4. TANH Function in Excel
MICROSOFT POWER BI Training
48+ Hours of HD Videos
8 Courses
Verifiable Certificate of Completion
Lifetime Access
4.5
MS Excel & VBA for Data Science
128+ Hours of HD Videos
24 Courses
10 Mock Tests & Quizzes
Verifiable Certificate of Completion
Lifetime Access
4.5
All-in-One Financial Analyst Masters Training Program
1000+ Hours of HD Videos
43 Learning Paths
250+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.9
All in One Data Science Bundle (360+ Courses, 50+ projects)
1500+ Hour of HD Videos
80 Learning Paths
360+ Courses
Verifiable Certificate of Completion
Lifetime Access
4.7
Primary Sidebar
Popular Course in this category
MS Excel Course
 223+ Hours of HD Videos
35 Courses
13 Mock Tests & Quizzes
  Verifiable Certificate of Completion
  Lifetime Access
4.9
Price

View Course
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Excel Charts
  • Excel Tips
  • All Tutorials
Certification Courses
  • All Courses
  • Excel VBA Course - All in One Bundle
  • VBA Course
  • Excel Data Analysis Course
  • Excel for Marketing Course
  • Excel for Finance Course
  • Excel for HR Training

ISO 10004:2018 & ISO 9001:2015 Certified

© 2023 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

EDUCBA
Free Excel Course

Excel functions, formula, charts, formatting creating excel dashboard & others

By continuing above step, you agree to our Terms of Use and Privacy Policy.
*Please provide your correct email id. Login details for this Free course will be emailed to you
Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you
EDUCBA

Download GROWTH Formula Excel Template

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

Download GROWTH Formula Excel Template

EDUCBA

डाउनलोड GROWTH Formula Excel Template

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more