Input the formula: =FORECAST(30,B2:B6,C2:C6). Press Enter to get the result. Referenced from Excel Help