Hello
I have seen some examples of the TREND function with different values of the constant (last argument of trend function)
e.g. TREND(A1:A2,,1) TREND(A1:A2,,2) TREND(A1:A2,,3) or any other integer
The outcome is quite different depending on the value of the constant ! It seems to do some kind of forecast.
The only documentation I can find is that this value should either be true or false and controls the b=0 value in the trend equation y = ax +b
Can anyone guide me to an explanation what this trend function does when putting an integer as argument in the constant.
Thanks
Canadane
Bookmarks