EDUCBA Logo

EDUCBA

MENUMENU
  • Explore
    • EDUCBA Pro
    • PRO Bundles
    • Featured Skills
    • New & Trending
    • Fresh Entries
    • Finance
    • Data Science
    • Programming and Dev
    • Excel
    • Marketing
    • HR
    • PDP
    • VFX and Design
    • Project Management
    • Exam Prep
    • All Courses
  • Blog
  • Enterprise
  • Free Courses
  • Log in
  • Sign Up
Home Excel Excel Resources Statistical Functions in Excel Excel GROWTH Formula
 

Excel GROWTH Formula

Madhuri Thakur
Article byMadhuri Thakur

Updated June 12, 2023

GROWTH Formula in Excel

 

 

GROWTH Formula in Excel

The growth formula in Excel is a statistical function. The 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. The 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. The growth formula is also used in Regression analysis in Excel.

Watch our Demo Courses and Videos

Valuation, Hadoop, Excel, Mobile Apps, Web Development & many more.

The growth function calculates Y values based on 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 for estimating 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 the Growth function to calculate the corresponding predictive 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 the exponential growth curve*

*Exponential Growth Curve in Excel:

For the 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 is 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, b is taken as 1; when this argument is not given, it is assumed as True and calculated normally.

This is a very helpful function to estimate or forecast exponential growth.

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 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 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 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 2019, 2020, and 2021.

Example 4

Now we will write the formula:

Here the known_y’s re cells B2: B10, known_x’s are the years 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 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

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 must be careful while writing the formula correctly. We will not get the correct result if we input the wrong syntax. It would rather give some errors. Some of these are as follows 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 the same as known_y’s.
  • 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 Use the exponential growth function as an array formula when you need to calculate multiple new values of y. So an array formula executes using the Crtl+ Shift+ Enter and not Enter.

Recommended Articles

This has been a guide to the GROWTH Formula in Excel. Here we discuss How to calculate GROWTH in Excel, 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

Primary Sidebar

Footer

Follow us!
  • EDUCBA FacebookEDUCBA TwitterEDUCBA LinkedINEDUCBA Instagram
  • EDUCBA YoutubeEDUCBA CourseraEDUCBA Udemy
APPS
EDUCBA Android AppEDUCBA iOS App
Blog
  • Blog
  • Free Tutorials
  • About us
  • Contact us
  • Log in
Courses
  • Enterprise Solutions
  • Free Courses
  • Explore Programs
  • All Courses
  • All in One Bundles
  • Sign up
Email
  • [email protected]

ISO 10004:2018 & ISO 9001:2015 Certified

© 2025 - 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
Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more

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
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?

EDUCBA

Download GROWTH Formula Excel Template

EDUCBA

डाउनलोड GROWTH Formula Excel Template

🚀 Limited Time Offer! - 🎁 ENROLL NOW