Article updated on June 20, 2018

The TREND function calculates values along a linear trend. Fits a straight line (using the method of least squares) to the arrays known_y's and known_x's.

It returns the y-values along that line for the array of new_x's that you specify.

Array formula in cell D8:D11


Excel Function Syntax

TREND(known_y's, [known_x's], [new_x's], [const])


nown_y's Required. The set of y-values you already know in the relationship y = mx + b.
[known_x's] Optional. An optional set of x-values that you may already know in the relationship y = mx + b. Default values are 1, 2, 3 ...
[new_x's] Optional. New x-values for which you want TREND to return corresponding y-values. If you omit new_x's, it is assumed to be the same as known_x's.
 [const] Optional. A logical value specifying whether to force the constant b to equal 0.


The following chart shows the TREND function plotted red.