Whole document tree INTERCEPTDescriptionINTERCEPT function calculates the point where the linear regression line intersects the y-axis. If @known_x or @known_y contains no data entries or different number of data entries, INTERCEPT returns #N/A error. If the variance of the @known_x is zero, INTERCEPT returns #DIV/0 error. This function is Excel compatible. |