FORECAST(x,Dependent, Independent) returns a value along a linear trend : FORECAST « Statistical functions « Microsoft Office Excel 2007 Tutorial






  1. Microsoft Office Excel 2007 Tutorial
  2. Statistical functions
  3. FORECAST
Input the formula: =FORECAST(30,B2:B6,C2:C6). Press Enter to get the result.
Input the formula: =FORECAST(30,B2:B6,C2:C6)

Referenced from Excel Help

21.27.FORECAST
21.27.1.FORECAST(x,Dependent, Independent) returns a value along a linear trendFORECAST(x,Dependent, Independent) returns a value along a linear trend