x,known_ys,known_xs!This function is available for compatibility with (!idspnExcel_2013) and earlier.Calculates, or predicts, ...

!x,known_ys,known_xs!!This function is available for compatibility with (!idspnExcel_2013) and earlier.Calculates, or predicts, a future value along a linear trend by using existing values!is the data point for which you want to predict a value and must be a numeric value!is the dependent array or range of numeric data!is the independent array or range of numeric data. The variance of Known_x's must not be zero!