Zoho Sheet GROWTH Function: Exponential Forecasts with Examples
Use GROWTH in Zoho Sheet to forecast exponential trends, check input assumptions, and compare projected values with linear TREND forecasts.
Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Zoho Sheet. How formula examples are checked
Quick answer. Use =GROWTH(B2:B6;A2:A6;D2:D4) when B2:B6 holds positive observed values, A2:A6 holds the matching period numbers, and D2:D4 holds future periods. Zoho documents GROWTH as an exponential-curve fitting and prediction function that returns an array of fitted or forecast values. A rising series that increases by a percentage rather than a fixed amount is a more suitable starting point for this model than a straight-line trend. [Z-GROWTH, checked 2026-10-12]
For example, a perfect series of 6, 12, 24, 48 and 96 at periods 1 through 5 follows y = 3 × 2^x. Its independently calculated forecasts for periods 6–8 are 192, 384 and 768. These are mathematical expected results, not results observed in a Zoho Sheet session.
Exact syntax and arguments
Zoho’s current English reference gives the following notation. Square brackets mean optional arguments; do not type the brackets. This article uses the semicolon separators shown in Zoho’s reference. Spreadsheet locale settings may affect how you enter formulas; do not silently replace punctuation in an existing workbook. [Z-GROWTH]
GROWTH(y_values; [x_values]; [new_x_values]; [allow_factor])
| Position | Argument | Required? | Meaning and documented behaviour |
|---|---|---|---|
| 1 | y_values |
Yes | Range or array of known dependent observations, such as B2:B6. |
| 2 | x_values |
No | Known independent variable(s), e.g. A2:A6; must match the shape/size of the known Y observations. If omitted, Zoho documents sequential positions {1,2,3,...}. More than one X variable is documented, but this guide’s worked examples use one variable. |
| 3 | new_x_values |
No | Positions to predict, such as D2:D4. Zoho shows this argument in square brackets but does not explicitly spell out its omitted-value behaviour in this individual reference; do not assume an Excel default is verified in Zoho. |
| 4 | allow_factor |
No | Logical flag controlling the fitted multiplicative constant b. Defaults to TRUE. FALSE fixes b = 1; TRUE or nonzero fits b to the observations. |
For one independent variable, the interpretable model is y = b × m^x, where b is the scale at x = 0 and m is the factor per one-unit increase in x. If m = 1.12, the model implies approximately 12% growth per unit of X; if m = 0.95, it implies approximately 5% decline per unit. This is mathematical interpretation, not a claim that every business trend is truly exponential. Zoho’s rendered reference equation contains formatting artifacts, so its arguments and descriptions, not the broken typography, are the source for the flag definitions. [Z-GROWTH; Z-LOGEST]
Availability and platform scope
GROWTH is present in the current public English Zoho Sheet statistical-functions knowledge base. The reference does not publish a per-function first-supported version, an account-tier availability matrix, or uniform desktop/mobile/client behaviour. Zoho’s product update page was checked separately, but no dated release note establishing those details for this function was identified. Accordingly, this guide makes no historical version or universal platform claim. [Z-GROWTH; Z-WHATS-NEW]
Example 1: forecast doubling demand — complete practice data
Create a blank sheet and enter the following values. Keep period numbers numeric, not typed strings; later periods must represent the same unit (weeks, months, and so on) as earlier periods.
| Row | A: Period | B: Orders | D: Period to forecast | E: Expected forecast |
|---|---|---|---|---|
| 2 | 1 | 6 | 6 | 192 |
| 3 | 2 | 12 | 7 | 384 |
| 4 | 3 | 24 | 8 | 768 |
| 5 | 4 | 48 | ||
| 6 | 5 | 96 |
- Enter the known period numbers in
A2:A6and known orders inB2:B6. - Enter
6,7,8intoD2:D4. - Enter
=GROWTH(B2:B6;A2:A6;D2:D4)in an output location with sufficient empty cells for the array result. Zoho documents an array; the precise spill/selection behaviour for your client has not been independently executed in Zoho. - Check the resulting three values against the independently calculated expectations:
192,384,768. If output placement differs, consult the current application’s array-formula entry instructions rather than applying Excel-specific key sequences.
Why those numbers? Every Y observation doubles when X increases by one, so the model is y = 3 × 2^x. At x=6, 3 × 2^6 = 192; at x=7, 3 × 2^7 = 384; at x=8, 3 × 2^8 = 768. A perfect doubling model is a teaching example, not a realistic guarantee about future demand.
Example 2: omit X values only when row order really means time
The known Y observations in Example 1 are evenly spaced and ordered, so Zoho’s documented default sequential X positions apply. This makes =GROWTH(B2:B6) a relevant simplified fitting request, but Zoho’s individual reference does not establish the exact returned output positions when new_x_values is also omitted. For unambiguous forecast intent, supply both the known and requested periods explicitly:
=GROWTH(B2:B6;A2:A6;D2:D4;TRUE)
If you supply no x_values, ensure that inferred positions {1,2,3,4,5} really match your sampling scheme. For dates with skipped weeks or irregular timestamps, build a consistent numeric X column instead of assuming adjacent rows mean equal time intervals.
Example 3: intentionally fix the constant to 1
For a second small dataset, put 1,2,3,4,5 in G2:G6, and 2,4,8,16,32 in H2:H6. Put 6 into I2. The request:
=GROWTH(H2:H6;G2:G6;I2;FALSE)
fixes b=1, giving y = 2^x. The mathematically expected prediction is 64. This is not a general recommendation to turn the factor off: on data generated by 3 × 2^x, forcing b=1 changes the fitted model and its forecast. The flag is a modelling constraint, not a switch for whether the function forecasts at all. [Z-GROWTH]
Advanced application: validate a non-perfect growth trend
Consider six monthly lead counts 105, 118, 131, 151, 171, 194, in B2:B7, with month indices 1 through 6 in A2:A7. This series is not exactly exponential. A reproducible independent least-squares fit to the natural logarithms gives approximately:
ln(predicted leads) = 4.5219898063 + 0.1235573816 × month
predicted leads = 92.018514952 × (1.131514931)^month
The corresponding independently computed predictions for months 7–9 are 218.5230, 247.2621, and 279.7807. With D2:D4 containing 7, 8, 9, the Zoho formula to investigate is:
=GROWTH(B2:B7;A2:A7;D2:D4;TRUE)
A transparent audit method is to create a helper column C2:C7 of =LN(B2) filled down, then calculate an independently checkable model using supported statistical functions:
=EXP(INTERCEPT($C$2:$C$7;$A$2:$A$7)+SLOPE($C$2:$C$7;$A$2:$A$7)*D2)
Fill that formula down next to the future months, if your account supports the referenced functions as documented. This uses natural-log regression, so its predicted output is exponential in the original units. The independent model’s mean absolute error on the six training observations is about 0.7887 leads, but a low training error does not validate future forecasts. A stronger business process holds back the most recent month as a test period, refits on earlier observations, and compares forecast against the held-out actual value.
When GROWTH is a poor fit
A straight increasing amount per period suggests TREND instead. Seasonal cycles, promotions, supply limits, cancellations, and a capped customer population also violate a simple constant-percentage picture. Values at or below zero are not admissible to the usual log-linear exponential fit; clean or model them explicitly rather than adding an arbitrary constant without documenting why. Zoho’s page lists generic formula errors but does not document a specific GROWTH error code for each such case, so this article does not invent one. [Z-GROWTH]
Errors, edge cases and troubleshooting
| Problem | What to check | Evidence/limits |
|---|---|---|
#NAME! |
Function spelling, formula separator for your locale, and any named ranges. | Zoho lists #NAME! as a general possible formula error. [Z-GROWTH] |
#VALUE! |
Numeric X and Y cells; dates stored as actual dates/numbers; accidental text; correct logical flag. | Zoho lists wrong data types as a general cause. [Z-GROWTH] |
#REF! |
Deleted or moved columns or invalid references. | Zoho’s generic explanation. [Z-GROWTH] |
#N/A! or too few predicted values |
Check X/Y dimensions, target X count, valid input observations; confirm how the app handles an array. | Zoho lists #N/A! generally, but does not assign it specifically to every GROWTH shape failure. [Z-GROWTH] |
| Implausibly fast growth | Check whether periods are monthly vs yearly and whether one outlier dominates the log fit. | Model interpretation; not a product error. |
Zeros, negatives or nonnumeric y_values |
A log-linear model requires positive numeric responses. Review imported missing-value codes and decide on a justified alternative. | Mathematical restriction; Zoho-specific error outcome not native-tested. |
| Multiple independent variables | Zoho documents more than one X variable. Verify orientation, shape, and interpretation in your own spreadsheet before using a multi-factor forecast. | No claim of equivalent multi-X layout across clients. |
| Blank or blocked output cells | Confirm the output region is empty and the formula is entered as required by the current Zoho UI. | Native spill mechanics not tested here. |
Exponential extrapolation can become extreme in only a few periods: at m=2, extending three periods multiplies forecasts by eight. Present scenario ranges and an explicit time horizon, not an unjustified point forecast presented as certain.
GROWTH versus LOGEST, TREND and Excel
- GROWTH returns fitted or forecast Y values along an exponential model.
LOGESTreturns the exponential model’s coefficients and, optionally, fit statistics. Zoho documents both functions and their use together. [Z-GROWTH; Z-LOGEST] TRENDpredicts along a straight line rather than an exponential curve.LINESTreturns linear-model coefficients/statistics. These differences are documented by Zoho, not inferred from name matching. [Z-TREND; Z-LINEST]- Excel also uses the name GROWTH with known-Y, known-X, new-X, and constant arguments, but Microsoft documents its own treatment of dynamic/legacy array entry and input errors. Those are Excel rules, not confirmed Zoho Sheet rules. Microsoft’s English syntax examples commonly use commas where Zoho’s reference shows semicolons. [MS-GROWTH]
- Google Sheets may present a similar-named function, but no Google documentation was checked for parity in this batch. Do not claim identical omission defaults, error handling or array placement on that basis.
Reusable checklist and validation disclosure
Before relying on a projection, verify the period scale, positive numerical responses, equal-sized X and Y inputs, target X values, fitted constant choice, and whether a held-out period supports the result. Keep actual observations separate from forecast output, and identify formulas as models, not facts.
Research status (2026-10-12): Zoho’s official function article and related references were inspected; mathematical examples were calculated independently using Python, not a Zoho execution environment. Native Zoho Sheet formula execution: NOT RUN. Excel/Google execution: NOT RUN. Web/desktop/mobile/account-specific array behaviour and first-supported product version: NOT VERIFIED.
References and check dates
- [Z-GROWTH] Zoho, GROWTH — official help, checked 2026-10-12. Supports exact syntax, arguments, default for
x_valuesandallow_factor, examples and general error table. - [Z-LOGEST] Zoho, LOGEST — official help, checked 2026-10-12. Supports the exponential-coefficient companion and its parameters.
- [Z-TREND] Zoho, TREND — official help, checked 2026-10-12. Confirms straight-line prediction distinction.
- [Z-LINEST] Zoho, LINEST — official help, checked 2026-10-12. Confirms linear coefficient/statistic counterpart.
- [Z-WHATS-NEW] Zoho, What’s New, checked 2026-10-12. Reviewed for release-specific context; not used to assert a GROWTH introduction date.
- [MS-GROWTH] Microsoft, GROWTH function in Excel, checked 2026-10-12. Excel-only comparison, not independent Zoho evidence.