Get help

Help center

Guides and answers

Contact support

Write to our team

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Finance

Turn manual finance work into reports that update themselves.

What Finance teams automate

  • Track payables and receivables
  • Build cash flow statements
  • Compare budget against actuals

Inventory and manufacturing

See stock levels and automate ordering.

What inventory and manufacturing teams automate

  • Track inventory across multiple sites
  • Connect sales, purchasing, and warehouse data
  • Link a barcode scanner to your sheet

HR

Run recruitment, attendance, and OKR tracking from your sheets.

What HR teams automate

  • Track recruitment and onboarding
  • Record team OKRs and results
  • Track check-ins, check-outs, and leave

Project management

Assign tasks and track hours without manual updates.

What project teams automate

  • Assign tasks and track status changes
  • Estimate effort and log hours worked
  • Track milestones across projects

Sales and CRM

Track leads and sales performance with automated reports.

What sales teams automate

  • Track and convert leads
  • Set sales goals and track team metrics
  • Monitor sales KPIs on dashboards

Education

Automate attendance, grades, and school purchasing.

What schools automate

  • Track attendance and notify parents
  • Record and compare class grades
  • Track inventory lent to students and staff

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Sign in to

Workflows

Build processes with your team

Automations

Connect files and automate tasks

One system, four parts

AI agents

Virtual Employees that work 24/7

Automations

Connect files and automate tasks

Workflows

Build processes with your team

Data Space

Trusted data sharing and control

Solutions by department

Finance

Reports, budgets, and reconciliations

Inventory and manufacturing

Stock, orders, and production in one view

HR

Timesheets, attendance, and reviews

Project management

Status and workload across projects

Sales and CRM

Leads and deals kept up to date

Education

Student records and school data

Find a use case

By department

How each team uses Sheetgo

By industry

How each industry uses Sheetgo

By company size

Small, medium-sized, or large

Get started

Templates

Ready-made workflows to start from

Learn

Blog

Guides and product news

Customer stories

How teams like yours use Sheetgo

Help center

Guides and answers

Why Sheetgo

Compare

How Sheetgo compares with other tools

Security

How we protect your data

Trust center

Our compliance details

Help center

Guides and answers

Contact support

Write to our team

Workflows

Build processes with your team

Automations

Connect files and automate tasks

Excel GROWTH function: how to use and examples

Let’s say you’ve introduced new products or services to your business that have started doing very well. Not only do your revenue figures increase every month, but the “increase” itself is also growing. If you want to predict your future expenses, looking at the figures for previous years, you might notice that they’ve started growing exponentially as well.

Whichever the case, you can use Excel’s GROWTH function to obtain an estimate for the next month or year. If your figures show linear growth, you should use the TREND function instead.

In this article, you will learn what the GROWTH function in Excel is and how to use it to predict future values based on existing ones. In addition to the known values for the dependent variable, you can also include values for one or more independent variables.

What is Excel’s GROWTH function?

The GROWTH function predicts future values based on the assumption of exponential growth.

To calculate this, the Excel GROWTH function requires values you already have for the dependent variable (known_y’s).

As for the optional values, these include those corresponding to the independent variable which you may or may not have (known_x’s), and those for which you’d like to find new values (new_x’s). The last is a logical value to determine the constant (const).

If your values show linear growth, you can use the TREND function to estimate future values. The same straight-line idea is behind linear regression in Google Sheets.

GROWTH function syntax

The syntax for Excel’s GROWTH function is shown below:

=GROWTH(known_y's, [known_x's], [new_x's], [const])

  • known_y’s (required): These are the values you already have for the dependent variable. If any of the values in this array is 0 or negative, you will get the “#NUM!” value error.
  • known_x’s (optional): An optional set of values for the independent variable, which you may already have. If you don’t, you can omit this parameter.
  • new_x’s (optional): The new values of the independent variable (x), for which you want to find the values of the dependent variable (y). If this parameter is omitted, it is assumed to be the same as the known_x’s. If both known_x’s and new_x’s are omitted, they are assumed to be the array {1,2,3,…}.
  • const (optional): A logical value that determines whether or not the constant (b) will be calculated:
    • If TRUE or omitted, b will be calculated.
    • If FALSE, b will be equal to 1. The formula is then adjusted to y = m^x.

To learn more about using this function with multiple variables in the form of complex arrays and vectors, visit Microsoft’s support page on this function.

How to use Excel’s GROWTH function?

The GROWTH function can return a value or an array of values. This is how you can use the GROWTH function in your worksheet to predict a single value and to predict an array of values.

Use GROWTH to predict a value

In the spreadsheet shown below, we have the values for monthly revenue for the last eleven months. I will use the GROWTH function to estimate the expected revenue for the next month, assuming exponential growth.

One column contains the values for the monthly revenue, known_y’s, and a second column contains the values for the month number known_x’s.

1. Click on the cell where you want the predicted value for revenue to appear. Here, B13.

Excel growth function — month numbers 1 to 12 and monthly revenue in euros, with empty cell B13 selected for the month 12 prediction

2. Type in the formula (see GROWTH function syntax above) and select the known_y’s, that is all cells containing the revenue values. Then, add a semicolon to trigger the next argument. Here, “B2:B12;”. The screenshots use semicolons to separate arguments. If your version of Excel uses commas, type a comma wherever these steps say semicolon.

Excel growth function — =GROWTH(B2:B12 typed in B13 with the revenue range highlighted and the argument tooltip below

3. After the semicolon, include the range for known_x’s and add a semicolon before entering the next argument.

Excel growth formula — =GROWTH(B2:B12;A2:A12 in the formula bar with the month numbers in column A highlighted as known_x's

4. Select the cell with the new_x’s (here, “A13”) and add a semicolon to trigger the options for the const argument.

Excel growth formula — =GROWTH(B2:B12;A2:A12;A13 with cell A13, month 12, selected as new_x's

5. The values for const are “FALSE – b is set equal to 1” or “TRUE – b is calculated normally”. If you choose “TRUE” or leave it empty, the value for “b” is calculated. If you choose “FALSE”, it will be set equal to 1.

Excel growth function — const options list showing FALSE, b is set equal to 1, and TRUE, b is calculated normally

6. Finish the formula by adding the closing parenthesis and press “Enter”.

Excel growth function — finished formula =GROWTH(B2:B12;A2:A12;A13;TRUE) in cell B13 before pressing Enter

7. Excel will now show the predicted value for the next month in the cell you initially selected.

Excel growth function — B13 returns a predicted revenue of 1.491.620,76 euros for month 12

Use GROWTH to predict an array of values

Let’s say your spreadsheet contains values for yearly expenses over the last six years. Use the GROWTH function to estimate the expenses for the next three years, assuming exponential growth.

In the first column, you can include the years, known_x’s, and the second column should contain the values for the yearly expenses, known_y’s. To predict three new values for known_y’s, you’ll need to use the function as an array formula.

1. Select the cells where you want the new values for expenses, new_x’s, to show.

Excel growth function array — yearly expenses for 2016 to 2021 with cells B8 to B10 selected for 2022 to 2024

2. Click on the formula bar and type in the GROWTH function. Select the known_y’s and add a semicolon to trigger the next argument.

Excel growth function array — =GROWTH(B2:B7 typed with the 2016 to 2021 expenses highlighted

3. Select the known_x’s and add a semicolon to trigger the next argument.

Excel growth formula array — =GROWTH(B2:B7;A2:A7 with the years 2016 to 2021 highlighted as known_x's

4. Select the new_x’s and add a semicolon to see the options for const.

Excel growth formula array — =GROWTH(B2:B7;A2:A7;A8:A10 with the years 2022 to 2024 selected as new_x's

5. The values for const are “FALSE – b is set equal to 1” or “TRUE – b is calculated normally”. If you choose “TRUE” or leave it empty, the value for “b” is calculated. If you choose “FALSE”, it will be set equal to 1.

Excel growth function array — const options list with FALSE and TRUE after the new_x's range A8:A10

6. After adding the final parenthesis, remember to press Ctrl + Shift + Enter for the array of values to be returned correctly. In Excel for Microsoft 365 and Excel 2021 or later, you can type the formula in the first cell and press Enter. The results spill into the cells below.

Excel growth function array — =GROWTH(B2:B7;A2:A7;A8:A10) in the formula bar, ready for Ctrl + Shift + Enter

7. Excel should now return the predicted values for the next three years in the corresponding cells.

Excel growth function array — predicted expenses for 2022, 2023 and 2024 returned by the array formula in braces

GROWTH function vs growth rate formula in Excel

The GROWTH function and a growth rate formula answer different questions. GROWTH predicts future values, such as next month’s revenue. A growth rate formula tells you how much a value changed, as a percentage.

To get the growth rate between two periods, subtract the old value from the new one and divide by the old value:

=(B3-B2)/B2

Format the cell as a percentage to read the result. Our guide to calculating year-over-year growth walks through this formula with an example.

For the average yearly growth over several years, use the compound annual growth rate (CAGR):

=(end_value/start_value)^(1/years)-1

Excel’s RRI function gives the same result with =RRI(years, start_value, end_value). The CAGR formula guide uses Google Sheets, but the formula works the same way in Excel.

Conclusion

As you have seen, Excel’s GROWTH function is useful if you need a future estimate and the values you already have show exponential growth. For linear growth, the TREND function is more appropriate. To check which pattern your figures follow, start with a trend analysis.

You now know how to use the GROWTH function to predict both a single future value and an array of values based on known values for two variables. In the first example, the function was used to calculate the predicted value for revenue in the next month. In the second, the function was used to calculate the predicted expenses for the next three years.

If your revenue figures live in several spreadsheets, Sheetgo, an AI-powered data automation platform, can pull them into one file on a schedule. Your GROWTH forecasts then run on current data that is ready for AI. To build the full forecast, read our guide to revenue forecasting.

You may also like…

IRR formula Excel — Excel logo and fx symbol above =IRR(values; [guess]) on a light orange background

How to calculate IRR in Excel? (IRR function and formula)

Use the IRR formula in Excel to find an investment’s internal rate of return. Compare two projects with IRR and NPV, and learn to calculate IRR by hand.

Excel INDIRECT function — Excel logo and fx icon above =INDIRECT on a light gray background

Excel INDIRECT function: formula and examples

Use the INDIRECT function Excel provides to turn text into a cell reference. See the syntax and examples with SUM, AVERAGE, ROW, and other sheets.

How to round off numbers in Excel — Excel icon next to .00 rounded to .0

How to round off numbers in Excel with the ROUND function

Learn to round off numbers in Excel with ROUND, ROUNDUP, and ROUNDDOWN, to any number of decimal places or to the nearest whole number.