How do I get an intermediate value between data points on a graph?

I have a set of x,y data points and I need to find/use a value between the
known x values. How can I get this info acurately and into a cell so I don't
have to scale it off the graph?

The FORECAST() function does an excellent job of interpolation.

See the Help description
--
Gary''s Student


"bman in co" wrote:

> I have a set of x,y data points and I need to find/use a value between the
> known x values. How can I get this info acurately and into a cell so I don't
> have to scale it off the graph?