Sorry David I missed out a 'Not'

You are on the correct track; that is what I am trying to do assume a
straight line between the two points. Not sure why i can not get this to
work. I tried the (Slope & Intercept ) on two set of figures and I can not
get them to work. It is making feel pretty dim at the moment.

Thanks for your help

"David Billigmeier" wrote:

So this IS or ISN'T what you were looking for? In your reply to Dave F you
said none of those functions work... and then you told me that does work.

Do you need like a slope/intercept? Like y=m*x+b, in this case:
m (slope) =SLOPE(B1:B20,A1:A20)
b (intercept) =INTERCEPT(B1:B20,A1:A20)

--
Regards,
Dave


"Steve J. Vaughan" wrote:

Thanks Dave this function will produce the results I am looking for.

I really need the formula that produces the curve but I can not get that


"David Billigmeier" wrote:

Use FORECAST(). So in your example, say your x values are in the range
A1:A20 and your y values are in the range B1:B20:

=FORECAST(x_to_predict,B1:B20,A1:A20)

--
Regards,
Dave


"Steve J. Vaughan" wrote:

Approximating a curve

I have a set of X and Y values for example

X Y
690 0.82
1400 1.72
2075 2.75
2760 3.93
3450 5.31
4150 6.68
4800 8.27
5500 8.34
7600 12.48
11750 8.27
14000 10.68
20000 19.51
24000 25.86
26500 28.89
28500 31.37
32500 33.3
34500 30.3


I need to calculate a value of Y for any value of X.

Is there a F(x) that will allow me to do this.

VLOOKUP is no good as a value of X from 20,001 to 23,999 will give the same
value of Y 19.51