How to Use Excel's Intercept Function

1. Find the function field at the top of the page, with the = sign to the left. This is where you can program a cell value. If the function field is not immediately available, you can go to 'Insert' and select 'Function.'
2. In your function field, add the operator INTERCEPT.
3. Start a parenthetical statement after INTERCEPT. Your values and parameters will all be inside a set of parentheses.
4. Add a cell range for your 'y axis.' The most common arrangement might be a range of values for a y axis in the A column of the spreadsheet, and a range of values for an x axis in the B column. In this case, your cell range, joined by a colon, would look something like this: A2:A7.
5. Add a comma, then add the range of cell values for the x axis, such as: B2:B7.
6. Close your parentheses. Your statement should look like this: INTERCEPT (A2:A7, B2:B7). Adding this to a function field for a cell will make that cell's value the point at which your x and y axis converge.