Contact
12 programs
Explore the site

Zoho Sheet FORECAST Function: Predict a Value with Linear Regression

Statistical Intermediate Zoho Sheet

Use FORECAST in Zoho Sheet to predict a dependent value from paired known data, with worked examples and regression checks.

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: Enter =FORECAST(new_x_value; y_values; x_values) to estimate the y-value at a new x-position using a fitted straight line. For six weeks of order counts stored in A2:A7 and B2:B7, =FORECAST(7;B2:B7;A2:A7) has an independently calculated expected result of 10.666666667 orders. That is a numerical forecast, not a certainty or a whole-item order quantity. Zoho official FORECAST reference, checked 2026-10-12.

FORECAST is useful when a roughly linear trend is meaningful: for example, estimating future demand, expected production volume or an approximate staffing workload. It predicts one response from one input using the existing points. It does not model seasonality, guarantee future outcomes, or automatically generate uncertainty bands. A historical relationship may be strong without proving a future increase. If a series changes direction or has outliers, inspect the data and compare alternatives before acting on the result.

Official syntax and argument order

FORECAST(new_x_value; y_values; x_values)
Argument Required? Officially documented meaning Example
new_x_value Yes Numeric x-position at which to predict a y-value. 7, or a cell such as D2
y_values Yes A single row/column of known dependent results. B2:B7 (orders)
x_values Yes A single row/column of corresponding independent observations. A2:A7 (weeks)

Zoho explicitly requires x and y inputs to have the same size. There are no optional parameters or documented defaults in this syntax; the explanatory argument labels are not literal text to type. The order is target x, known y, known x—it is easy to swap the latter two accidentally. As of the checked individual reference, Zoho documents FORECAST; this guide does not establish support for a FORECAST.LINEAR alias. Zoho FORECAST, checked 2026-10-12.

Reproduce the example dataset

Create a new worksheet for the example and enter these six observations. The A column is the independent variable (week number); B contains the dependent variable (orders). Enter numbers, not quoted text.

Row A: Week B: Orders
1 Week (heading) Orders (heading)
2 1 3
3 2 5
4 3 4
5 4 8
6 5 7
7 6 10

This is an illustrative synthetic dataset, not downloaded Zoho Sheet output or a claim about actual business demand. The arithmetic below has been independently checked against these values. Formulas use the semicolon separators shown in Zoho’s English-language function help. If your spreadsheet’s formula parser requires another separator, check the workbook’s locale/settings rather than copying translated notation blindly.

Example 1: forecast the next week, step by step

  1. Leave A1:B7 exactly as shown above. Set D1 to Next week and E1 to Forecast orders.

  2. Type the number 7 into D2. Enter this formula in E2:

    =FORECAST(D2;B2:B7;A2:A7)

  3. Expected calculated output: 10.666666667 (display precision depends on formatting). This is a continuous forecast; do not report it as exactly eleven observed orders.

  4. Put 8 in D3, then fill the same formula into E3 only after fixing the historical ranges, or use the safe copyable formula below:

    =FORECAST(D3;$B$2:$B$7;$A$2:$A$7)

    Expected result for week 8: 11.952380952. The dollar signs prevent the known-data ranges moving as the formula is filled downward.

For a reader who prefers a single formula without helper cells, =FORECAST(7;B2:B7;A2:A7) produces the same first estimate. These numerical outputs are independently derived, not observed Zoho Sheet executions.

Example 2: see why the forecast has that value

For a straight-line regression the predicted value is y-hat = intercept + slope × x. For our six observations, the independently calculated means are x̄ = 3.5 and ȳ = 6.166666667. The centered sums are Sxx = 17.5 and Sxy = 22.5; therefore the slope is 22.5 / 17.5 = 1.285714286, and the intercept is 6.166666667 - 1.285714286 × 3.5 = 1.666666667. So for week 7:

1.666666667 + 1.285714286 × 7 = 10.666666667

Zoho also documents these companion formulas, allowing a transparent cross-check (each requires native verification in your workbook):

=SLOPE(B2:B7;A2:A7)          
=INTERCEPT(B2:B7;A2:A7)      
=INTERCEPT(B2:B7;A2:A7)+SLOPE(B2:B7;A2:A7)*7

Their independently calculated expected results are 1.285714286, 1.666666667, and 10.666666667 respectively. This is useful for auditing a forecast: if the x/y ranges are accidentally reversed, the fitted equation and interpretation are different. References: Zoho SLOPE and Zoho INTERCEPT, both checked 2026-10-12.

Advanced application: a two-week ordering plan

Suppose a warehouse schedules replenishment for week 7 and week 8. Place 7 and 8 in D2:D3, then enter =FORECAST(D2;$B$2:$B$7;$A$2:$A$7) in E2 and copy to E3. The expected unrounded forecasts are 10.666666667 and 11.952380952 units. If quantities must be integers, rounding is a separate business decision. For example:

=ROUNDUP(FORECAST(D2;$B$2:$B$7;$A$2:$A$7);0)

The mathematically expected minimum whole-unit values are 11 (week 7) and 12 (week 8). For a deliberately conservative heuristic, one might add one historical regression residual standard error before rounding:

=ROUNDUP(FORECAST(D2;$B$2:$B$7;$A$2:$A$7)+STEYX($B$2:$B$7;$A$2:$A$7);0)

For week 7 this independently evaluates to 12; for week 8, 14. This is merely a transparent planning cushion, not an official confidence interval or an endorsed statistical safety-stock method. It ignores the larger uncertainty associated with extrapolation farther outside the observed range. Review lead times, variability, capacity and the cost of shortages; do not automate purchases from six observations alone. Official related references: Zoho STEYX and Zoho FORECAST, checked 2026-10-12.

Errors, edge cases and troubleshooting

Symptom Why it matters Recommended check
#N/A! Zoho specifically lists empty known-x/known-y ranges or different x/y counts for FORECAST. Compare COUNT and range dimensions; make sure both ranges refer to matching observations.
#NAME! Zoho lists unrecognized names, malformed references and spelling issues. Check FORECAST spelling, cell range colons and your locale’s argument separator.
#VALUE! An invalid argument type can trigger this Zoho-listed error. Ensure target x and known observations are numeric; remove imported numbers stored as text.
#REF! Zoho lists invalid/deleted cell references. Repair broken range links and check moved columns.
All x-values are identical The line’s slope is mathematically undefined (zero x-variance). Collect varying x-values; do not fabricate a slope. The exact Zoho display error for this situation was not independently tested.
Implausible forecast The line may be extrapolating too far or a few values dominate the result. Plot the observations, check units, inspect outliers, and compare fitted versus actual orders.
Formula changes as you drag it Relative references may shift the historical sample. Use absolute references for known ranges and relative reference for the next-week cell.

Zoho’s error table documents #N/A!, #NAME!, #VALUE! and #REF! for this function. Other mathematically undefined cases should not be assigned a specific untested Zoho error code. Zoho error reference, checked 2026-10-12.

In Microsoft Excel, both FORECAST(x, known_y's, known_x's) and FORECAST.LINEAR(...) are documented. Microsoft says FORECAST.LINEAR became its preferred new name starting with Excel 2016 while retaining FORECAST for compatibility. That is Excel history, not a first-support claim about Zoho. Microsoft also documents a #DIV/0! result for zero-variance x-inputs; it is not proof of an identical Zoho error display. Microsoft’s official FORECAST reference, checked 2026-10-12.

Zoho’s English reference uses semicolons. Spreadsheet locales can affect how dates and numbers are interpreted and displayed; Zoho documents workbook locale settings, but the source checked here does not establish that all clients/accounts use identical formula entry punctuation. No native cross-platform or historical-version test was performed. Zoho workbook locale settings, checked 2026-10-12. Google Sheets behaviour was not independently documented in this batch; do not assume a same-named function matches on all edge cases.

For one x-value use FORECAST; for transparent line components examine SLOPE and INTERCEPT; for line fit quality see RSQ; for typical regression scatter see STEYX. These are verified vendor help links, not assertions about published pages on Spreadsheet-Tutorials.com.

Verification and source notes

  • Official reference checked: Zoho Sheet FORECAST help, 2026-10-12; direct link.
  • Additional official references checked: Zoho SLOPE, INTERCEPT, RSQ and STEYX (2026-10-12); Excel FORECAST/FORECAST.LINEAR and Zoho locale settings (2026-10-12).
  • Documentation status: Syntax and named errors checked in Zoho’s published help; page does not state a verified first-supported Zoho version, per-device release scope, or account-tier restriction. None is invented here.
  • Calculation status: Regression coefficients, forecasts and integer rounding were independently reasoned/arithmetic-checked with the displayed six-row dataset.
  • Native Zoho Sheet status: NOT EXECUTED. No claim is made about native screenshots, imported workbook behaviour or observed cell outputs. No genuine Zoho Sheet screenshots are included; this guide uses no mock application images.