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

1. ## 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. ## 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

Ciao,

Koen