TREND

Definition: The TREND function in Excel is used to calculate the linear trendline for a set of data.

Syntax: ==TREND(known_y’s, [known_x’s], [new_x’s], [const]).

Situation: This formula is appropriate in situations where you need to calculate the linear trendline for a set of data.

Example: If you have a set of data in cells A1:B10, and you want to calculate the trendline for the data, you would use the formula =TREND(B1:B10, A1:A10). This would return a value that represents the slope of the trendline.