+ Reply to Thread
Results 1 to 2 of 2

Predict Sales increase Trend or Growth.

  1. #1
    Registered User
    Join Date
    12-03-2008
    Location
    Tulsa
    Posts
    18

    Predict Sales increase Trend or Growth.

    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.
    Attached Files Attached Files

  2. #2
    Forum Expert contaminated's Avatar
    Join Date
    05-07-2009
    Location
    Baku, Azerbaijan
    MS-Off Ver
    Excel 2013
    Posts
    1,430

    Re: Predict Sales increase Trend or Growth.

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1