What is TREND?
Returns values along a linear trend. Fits a straight line to data using least squares.
Syntax
=TREND(known_y's, [known_x's], [new_x's], [const])
Example
Formula: =TREND(A1:A5, B1:B5, B6)
Result: Predicted linear value
How It Works
Fits y = mx + b to data and predicts new values. Used for linear relationships and forecasting.