Statistical

FORECAST Function in Excel

Calculates a future value based on existing values using linear regression.

Syntax

  • =FORECAST(x, known_y's, known_x's)

Arguments

  • x (required): The data point for which to predict a value
  • known_y's (required): The dependent array or range of data
  • known_x's (required): The independent array or range of data

Examples

  • =FORECAST(6, B2:B10, A2:A10) - Predict value for x=6 - Result: Predicted Y value
  • =FORECAST(2025, Revenue, Years) - Forecast 2025 revenue - Result: Projected revenue

FORECAST for data analysis

  • Confirm whether you need entire columns, filtered subsets, or distinct values.
  • Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
  • Pivot tables complement single-cell statistical formulas for exploration.

Common errors

  • #N/A if arrays have different sizes
  • #DIV/0! if variance of x is zero

Use cases

  • Sales forecasting
  • Trend prediction
  • Budget planning
  • Demand forecasting

Frequently asked questions

  • What is the FORECAST function in Excel? FORECAST calculates a future value based on existing values using linear regression. The syntax is =FORECAST(x, known_y's, known_x's). Typical use cases include sales forecasting, trend prediction, budget planning.
  • How do I use the FORECAST function? To use FORECAST, type =FORECAST( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • What type of data does FORECAST work with? FORECAST works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
  • Why is FORECAST not working in my Excel? Common issues with FORECAST include #N/A if arrays have different sizes; #DIV/0! if variance of x is zero. Start by checking the syntax =FORECAST(x, known_y's, known_x's), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.