Skip to content
ExcelExcel 2016+

FORECAST.LINEAR function in Excel

Returns a future value based on existing values

=FORECAST.LINEAR(x)

FORECAST.LINEAR syntax and parameters

One argument, one required.

  • xnumberRequired

    If is nonnumeric, FORECAST and FORECAST.LINEAR return the #VALUE! error value.

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 Google Sheets

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 Excel gets this done.