Excel Function : FORECAST

Download now!

Excel Function : FORECAST




Returns a value along a linear trend

Microsoft Excel Reference Page


Syntax and Description of the FORECAST Excel Function

? The syntax for the FORECAST function in Microsoft Excel is: =FORECAST(x, known_y's, known_x's) where x is the value for which you want to predict a y-value, known_y's are the y-values for the known x-values, and known_x's are the x-values for the known y-values.

About FORECAST Excel Function

The FORECAST function predicts future values based on existing values. The function uses the least squares method to find the line of best fit for the given data. The function then predicts the y-value for the given x-value.