Hi,
I've tried the Trend Function on Cell H3 of the attached file but it was giving me "#Value!" as a result! Also tried putting it as array but to no avail.
Is there any formula that can derive the logarithmic and polynomial Forecast for the coming year in Excel? I can add the trendline on the chart but the line doesn't give me the values on the chart. Anyway, can anyone help to have the 2 Trend numbers on Cell H3 and I3?
Thanks in advance for your cooperation. Cheers!
Bookmarks