TREND

Syntax:

TREND(linest-data:Array|Range, x-data:Array|Range)

Takes the result of a LINEST function (the linest-data array) and applies it to the x-data array (or range of cells) to return corresponding estimated y-data array.

If x-data is of dimensions m×n and the LINEST function has returned n+1 coefficients, then you will get m output y-data, or vice versa.

Note that the estimated y-data may be very poor quality if any of the x-data values are beyond the limits of the x-data supplied to the LINEST function.