# Google Sheets GROWTH Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/growth-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The GROWTH function predicts exponential growth by calculating future values based on existing data points and a specified range. ``` GROWTH(known_data_y, [known_data_x], [new_data_x], [b]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the GROWTH you need in plain EnglishGenerate Formula ## Parameters **`known_data_y`**:\ The set of dependent data points (y-values) that you want to analyze and use for the growth calculation. **`known_data_x`**:\ The set of independent data points (x-values) that correspond to the `known_data_y`. This parameter is optional; if omitted, it defaults to the array {1, 2, 3, ...}. **`new_data_x`**:\ The new x-values for which you want to predict the corresponding y-values based on the growth trend. This parameter is also optional. **`b`**:\ A logical value that determines whether to force the intercept to be zero. If TRUE or omitted, the intercept is calculated normally; if FALSE, the intercept is set to zero. ## What is a GROWTH Function? The *GROWTH* function in Google Sheets is a statistical function used to predict exponential growth based on existing data. It is particularly useful for forecasting future values based on historical data points. This function can be applied in various fields such as finance, sales, and scientific research where growth trends are analyzed. In simpler terms, GROWTH allows you to estimate future values by analyzing the growth rate of a dataset, making it easier to make informed decisions based on trends. ## A Practical Example Imagine you are analyzing the sales growth of a product over several months: ### Sales Data Table: | Month | Sales | | - | - | | 1 | 100 | | 2 | 150 | | 3 | 200 | | 4 | 300 | You want to predict the sales for the next few months based on the existing data. ## GROWTH Formula To achieve this, you would use the GROWTH function as follows: ``` =GROWTH(B2:B5, A2:A5, A6:A8) ``` In this formula: - `B2:B5` is the range containing the existing sales data. - `A2:A5` is the range containing the corresponding months. - `A6:A8` is the range where you want to predict future sales (e.g., months 5 to 7). ## Result of the Formula When you apply the GROWTH formula to predict sales for the next three months, the output might look like this: | Month | Sales | Predicted Sales | | - | - | - | | 1 | 100 | | | 2 | 150 | | | 3 | 200 | | | 4 | 300 | | | 5 | | 400 | | 6 | | 600 | | 7 | | 900 | In this case, the GROWTH function estimates that sales will be 400 in month 5, 600 in month 6, and 900 in month 7. ## Why Use GROWTH? GROWTH is beneficial because it simplifies the process of forecasting future values based on existing data. It provides a straightforward way to analyze trends and make predictions without needing complex calculations. This function is especially useful for businesses looking to project sales, revenue, or other metrics over time. ## Key Takeaways: - **GROWTH**: A statistical function that predicts future values based on existing data trends. - **Exponential Growth**: Ideal for datasets that exhibit exponential growth patterns. - **Forecasting**: Helps in making informed decisions by providing estimates for future performance. - **Common Use Cases**: Useful in sales forecasting, financial projections, and any scenario where growth trends are analyzed. GROWTH is an essential function for anyone working with data in Google Sheets, providing a powerful way to enhance data analysis and forecasting capabilities. Happy spreadsheeting! ## Example use case You have a table with sales data over several months in Column A and corresponding revenue figures in Column B. Use the GROWTH formula to forecast future sales based on historical data, enabling better inventory and marketing planning for upcoming months. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Lock Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-lock-cells-in-google-sheets) - [How To Make A Copy Of An Google Sheets Sheet](https://betteranalyst.com/google-sheets/how-to-make-a-copy-of-an-google-sheets-sheet) - [How To Make A Graph In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-graph-in-google-sheets) - [How To Make A Histogram In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-histogram-in-google-sheets) - [How To Make A Line Graph In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-line-graph-in-google-sheets) - [How To Make A Pie Chart In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-pie-chart-in-google-sheets) - [How To Make A Table In Google Sheets](https://betteranalyst.com/google-sheets/how-to-make-a-table-in-google-sheets) - [How To Merge Cells In Google Sheets](https://betteranalyst.com/google-sheets/how-to-merge-cells-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.