I am trying to €˜FORECAST or €˜TREND a series and neither function appears to
be working as I would expect. For example, I have the following series:
1,2,3,1,2,3,1,2,3,1,2,3 and I want to FORECAST or TREND the next 5 periods.

When I use the FORECAST (=FORECAST(M$1,$A10:L10,$A$1:L$1)) function, I get:
2.4, 2.4, 2.5, 2.5, 2.6

When I use the TREND (=TREND($A4:L4,$A$1:L$1)) Function, I get: 1.7, 2.2,
2.2, 2.3, 2.3

I would expect to get 1,2,3,1,2, for both functions.

Anyone know what I am doing wrong or if I should be using another function.

Thanks
--
Mike