Name
INTERCEPT
Synopsis
Use INTERCEPT to examine the x and y values to determine the point where a line will cross the y-axis.
To Calculate
=INTERCEPT(Known_Y's,Known_X's)
Both arguments are required for this function.
Example
Figure 15-23 illustrates how INTERCEPT compares the specified x- and y-axis values to determine the point where the line crosses the y-axis.
Figure 15-23. Use INTERCEPT to determine the point where the specified line crosses the y axis
Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
