TREND or FORECAST function
Results 1 to 2 of 2

Thread: TREND or FORECAST function
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Sep 2015
    Post Thanks / Like
    0 Post(s)
    0 Thread(s)

    Default TREND or FORECAST function

    I'm trying to trend out some numbers. I have two sets of numbers: The first we can call a "local" projection and the second we can call a "national" projection.

    For the national projection I know all 3 numbers: Low, Medium, High
    For the local projection I know only 1 number: Low

    I would like to use the TREND/FORECAST function to predict what the Medium and High numbers are for Local. Is this possible? Also not sure if it matters, but the High number is the more important one to know because if I know that, I can interpolate the Medium as the 50th percentile between the Low and High.

    The table below depicts what I'm trying to do with the 'X's representing what I need to use the TREND/FORECAST function to predict.

    Local Low National Low National Medium National High Local Medium Local High
    26 23 19 15 X X
    19 18 17 15 X X
    350 300 400 500 X X

    Any help would be much appreciated!

  2. #2
    Board Regular Rijnsent's Avatar
    Join Date
    Oct 2005
    Utrecht, Holland
    Post Thanks / Like
    1 Post(s)
    0 Thread(s)

    Default Re: TREND or FORECAST function

    Hi wring,

    why would you need a TREND or forecast formula... In your example I would simply use: E2: =A2/B2*C2 and F2: =A2/B2*D2


    You can't post attachments here, but you can help me helping you by posting a screen shot directly in your post with any of those tools.
    Otherwise use dropbox/google drive/etc to get your file accross (not preferred). For code, put it inside these tags: [ CODE][/CODE]. Do check the forum rules.
    Finally, please show that you made an effort to solve your problem: Yes, I like to help, but am not going to do your job.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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