TREND

Syntax:

TREND( linest-data:Range or Array, x‑data:Range or Array )

Takes the result of a LINEST() function (the linest-data array) and applies it to the x‑data range of cells (or array) 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.