MS Excel: Intercept Function
In Excel, the Intercept function returns the y-axis intersection point of a line using x-axis values and y-axis values.
The syntax for the Intercept function is:
Intercept( known_y_values, known_x_values )
known_y_values is the known y-values used to calculate the intersect.
known_x_values is the known x-values used to calculate the intersect.
Note:
If the known_y_values and known_x_values parameters contain different numbers of elements, the Intercept function will return the #N/A error.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:
Based on the Excel spreadsheet above:
=Intercept(A2:A5, B2:B5) would return 0 =Intercept({1,2,3,4}, {10,11,12,13}) would return -9 =Intercept({10,20,30}, {10,20,30}) would return 0