Functions
TREND
Returns values along a linear trend
Try it
When to use it
When should I use TREND?
Use TREND to project values along a least-squares linear fit — useful for forecasting sales, costs, or any metric that grows or shrinks at a roughly constant rate over time.
Used in
Syntax
TREND(known_y, [known_x], [new_x], [const])Examples
=TREND({1,2,3,4}) // => 1.0000000000000002
=TREND({2,4,6,8},{1,2,3,4}) // => 2.0000000000000004
=TREND({2,4,6,8},{1,2,3,4},{5}) // => 10