Excel Function : FORECAST.LINEAR

Download now!

Excel Function : FORECAST.LINEAR




Returns a future value based on existing values

Microsoft Excel Reference Page


Syntax and Description of the FORECAST.LINEAR Excel Function

The syntax for the FORECAST.LINEAR function in Microsoft Excel is: FORECAST.LINEAR(x, known_y's, known_x's) x - The value for which you want to predict a value known_y's - The set of y-values known to exist known_x's - The set of x-values corresponding to the known_y's

About FORECAST.LINEAR Excel Function

The FORECAST.LINEAR function predicts a future value by using the linear relationship between a set of known values and values that are predicted for the future. The known values are plotted on a line, and the function uses this line to predict the value for a given x-value.