Skip to content
Google Sheets

FORECAST.LINEAR function in Google Sheets

See

=FORECAST.LINEAR(x, data_y, data_x)

FORECAST.LINEAR syntax and parameters

Three arguments, three required.

  • xnumberRequired

    The value on the x-axis to forecast.

  • data_yrangeRequired

    The range representing the array or matrix of dependent data.

  • data_xrangeRequired

    The range representing the array or matrix of independent data.

FORECAST.LINEAR examples

Formulas you'll actually reuse.

  1. Next month's revenue from a year of monthly history:

    =FORECAST.LINEAR(13, B2:B13, A2:A13)

    Result13482.5

  2. Extrapolate a dated series to a specific future date:

    =FORECAST.LINEAR(DATE(2027,1,1), B2:B25, A2:A25)

FORECAST.LINEAR in Excel

Same name — your formula ports as-is.

Try FORECAST.LINEAR in the playground

Edit the example — nothing to install.

Preloaded with the FORECAST.LINEAR formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.