top of page
  • Writer's pictureDp

"FORECAST" Function In Excel

Updated: May 2, 2019

This function uses two sets of values to predict a single value.The predicted value is based on the relationship between the two original sets of values.If the values are sales figures for months 1 to 6, (Jan to Jun), you can use the function to predict what the sales figure will be in any other month.

The way in which the prediction is calculated is based upon the assumption of a Linear Trend.



ItemToForecast is the point in the future, (or past), for which you need the forecast.

RangeY is the list of values which contain the historical data to be used as the basis of the forecast, such as Sales figures.

RangeX is the intervals used when recording the historical data, such as Month number.


Video tutorial:

If you liked this tutorial, share it with your friends. And also you can follow us on Youtube, Twitter and Facebook. We would love to hear from you, Please do comment, suggest or compliment our work and we shall make it better for you.

You can write us at


Recent Posts

See All


bottom of page