From data to report in one minute or less. Ajelix BI is launched! 🚀 Get started for free.

How To Use FORECAST function in Excel Explained

What is FORECAST Function in Excel?

The FORECAST function in Excel is a statistical tool that predicts a future value based on existing data. It uses linear regression analysis to estimate the value of a dependent variable based on the values of one or more independent variables. The FORECAST function can create trend lines, forecast future sales or budget, and analyze data trends.


The FORECAST function in Microsoft Excel can predict future values based on existing data. This function is useful to businesses and individuals who need to anticipate future trends and plan accordingly.

The function uses linear regression to analyze existing data and extrapolate future values. It requires at least two sets of data points, such as dates and sales figures, and uses those points to create a linear trendline. The trendline is then used to predict future values.

The Forecast formula has a simple syntax, making it easy to use. It requires two arguments, the first being the data set to forecast from, and the second being the forecast period. Data sets can be a range of cells or a named range. The forecast period is simply the number of data points to forecast.

Once the Forecast syntax is entered, the results will be displayed in the cell where the function is entered. The results can be formatted to make them more legible, and the results can also be charted to provide a visual representation of the forecast.

The Forecast function can be used in a variety of situations, such as predicting sales figures, budgeting, and forecasting cash flow. It is a valuable tool for businesses and individuals who need to make decisions based on future trends.

Struggling with your Excel formulas?
Looking for a faster and easier way to write Excel formulas? Try AI Excel Formula Generator and turn your text into formulas with just a few clicks.

Try for free




x = the x-value for which you want to predict a corresponding y-value

known_y’s = a range of dependent values (y-values)

known_x’s = a range of independent values (x-values)

Forecast MS Function MS Excel - Ajelix Excel Formulas and Functions - Excel Formula Cheat Sheet

How to use FORECAST function MS Excel in your workbook:

  1. Open a new spreadsheet in Excel.
  2. Input the data that you want to forecast using the function.
  3. Select the cell where you want to the output of the forecast function to be displayed.
  4. Type the following function into the selected cell: =FORECAST(x, known_y’s, known_x’s)
  5. Replace the “x” with the value you want to predict.
  6.  Replace the “known_y’s” with the values of the dependent variable.
  7. Replace the “known_x’s” with the values of the independent variable.
  8. Press “Enter” to get the forecast value.

Frequently Asked Questions

How the FORECAST function work in Excel?

The function uses a linear regression algorithm to calculate a future value based on existing values. It takes two arguments, an existing value and the number of future values you want to generate. It then returns a series of values that are linearly distributed between the existing value and the predicted value.

How to use FORECAST in Excel?
  1. Select the data you want to forecast.
  2. Go to the Insert tab and select the Forecast icon in the Forecast section.
  3. In the Forecast dialog box, choose the desired forecasting method and options.
  4. Click OK to generate the forecast. 
  5. Rhe forecast will appear as a new column in your data set.

Read latest blog articles about Excel


How To Analyze Data In Excel Spreadsheet

How To Analyze Data In Excel Spreadsheet

Continue reading

How To Add Drop Down List in Excel

How To Add Drop Down List in Excel

Continue reading

How To Add Checkboxes In Excel

How To Add Checkboxes In Excel

Continue reading