The Insert Function tool on the Formula bar. Predicts a future point on a linear trend line fitted to a supplied set of x- and y- values New in Excel 2016 not Excel 2016 for Mac - replaces the Forecast function INTERCEPT Calculates the best fit regression line through a supplied series of x- and y- values and returns the value at which this line intercepts the y-axis. IF A2B2Over BudgetOK IF A2B2B4-A4 Argument name.
But before we begin lets first review the elements of the VLOOKUP function.
Click on the cell where you want your answer be placed. Next go to the Formulas tab then click Insert Function. The fruit seller is again here. Excel for Mac and Excel Online as well as a few examples.