Intermediate Values

[OneAngryDwarf]

does anybody know how to find an intermediate value on a scatter plot w/ a
line following the curve...not a trendline but just a well i guess u'd call
it a trace line. Basically I have a few numbers (two columns, one x, one y)
which creates a "utility" curve just a line connecting those dots. I'm
simply tring to find a way to ask it a number and have it return the
corresponding value along the curve... so if i gave it a number off the x
axis it would give me the y axis value.

 

[Aladin Akyurek]

Have a look at TREND, FORECAST, and GROWTH functions.