Excel Function: FORECAST

The Excel function FORECAST extrapolates a new data point based on known data.


=FORECAST(X, known_Ys, known_Xs)

Example of use

The aim here is to estimate revenue based on the evolution of previous years' revenue:

excel function forecast

Select the FORECAST function and enter:


forecast function png

Click OK.


All that remains is to add $ and drag the formula down:

excel function predict revenue year forecast