I need cell H2 to predict the sale trend based off the previous weeks percent of increase. I am doing something wrong. I know there is a simple fix. The formula does not have to be a linear prediction but whatever works best. Thank You in advance.
I need cell H2 to predict the sale trend based off the previous weeks percent of increase. I am doing something wrong. I know there is a simple fix. The formula does not have to be a linear prediction but whatever works best. Thank You in advance.
I think that your issue is bounded up with that u didn't show new x for TREND() function, and it should has been entered as array formula, e.g. with ctrl+shift+enter.
Take a look at this book. Here I have used three similar functions: FORECAST, TREND, GROWTH
Last edited by contaminated; 06-29-2009 at 05:02 PM.
Люди, питающие благие намерения, как раз и становятся чудовищами.
Regards, ?Born in USSR?
Vusal M Dadashev
Baku, Azerbaijan
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks