LINEST vs. SLOPE and INTERCEPT. The underlying algorithmic of the LINEST function differs from the algorithm used in the SLOPE and INTERCEPT functions. Therefore, when the source data is undetermined or collinear, these functions may return different results. Excel LINEST function not working If your...