How to Use MS Excel Forecast Formula

Written by c.d. crowder Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Use MS Excel Forecast Formula
Forecast Function Window (Microsoft Excel)

Microsoft Excel is a powerful tool for analysing data. The Forecast function provides users with a way of predicting a future value based on existing values. You must have existing values upon which to base the prediction. The Forecast function comes into play in analysing business trends, especially in finance. By forecasting future figures, a business or individual can prepare a better budget, make changes in employment, and see how well a business is doing overall.

Skill level:


  1. 1

    Open a Microsoft Excel spreadsheet. Use the existing spreadsheet with all necessary information or create a new one and input the desired data.

  2. 2

    Click your target cell. This is the cell in which the results will appear.

  3. 3

    Go to the Function Bar at the top of the screen. Click the fx button to display function assistance and further guide you through the process.

  4. 4

    Choose your X value. This is the value you're basing your prediction on. This value must be numeric.

  5. 5

    Choose the range of cells for your known Y values. These are the values that are dependent on your X values.

  6. 6

    Choose the range of cells for your known X values. These are the independent values.

  7. 7

    Click OK to view your results.

Tips and warnings

  • The known X and Y array values must contain the same number of values.
  • You can preview the results in the function assistance window before you click OK.
  • Once you are used to the formula, type =FORECAST( ). Insert your values separated by commas in the parentheses.
  • The variance of the known X values must not be zero or the result will be an error.

Don't Miss

  • All types
  • Articles
  • Slideshows
  • Videos
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the site, you consent to the use of cookies. For more information, please see our Cookie policy.