When working with time series, both of them return the same result since they use the same mathematical method. The difference between these two is that the FORECAST function works only as a regular formula returning one value as output. In contrast, the TREND function can be used as an array formula and calculate multiple y values corresponding to multiple x values.