Intercept

Syntax

Intercept(Year1, Value1, Year2, Value2,... YearN, ValueN) or
Intercept(ExcelFilename, ExcelRangeName)
Intercept(Branch:Variable)

See also: Using Time-Series Functions

Summary

Calculates the point at which a line will intersect the value axis by using existing values and years. The intercept point is based on a best-fit regression line plotted through the known years and values.   Use the intercept when you want to determine the value when the  year is 0 (zero).