TREND or FORECAST function

[wring]

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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Local Low[/TD]
[TD]National Low[/TD]
[TD]National Medium[/TD]
[TD]National High[/TD]
[TD]Local Medium[/TD]
[TD]Local High[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]23[/TD]
[TD]19[/TD]
[TD]15[/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]18[/TD]
[TD]17[/TD]
[TD]15[/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
[TR]
[TD]350[/TD]
[TD]300[/TD]
[TD]400[/TD]
[TD]500[/TD]
[TD]X[/TD]
[TD]X[/TD]
[/TR]
</tbody>[/TABLE]


Any help would be much appreciated!

 

[Rijnsent]

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