Mega Code Archive
Categories
/
MSOfficeExcel 2007 Tutorial
/
Statistical Functions
FORECAST(x,Dependent, Independent) returns a value along a linear trend
Input the formula: =FORECAST(30,B2:B6,C2:C6). Press Enter to get the result. Referenced from Excel Help