Mark -

Search the newsgroup archives for 'interpolate'

http://www.google.com/advanced_group_search

or if you want to try to match the smoothed curve Excel draws arbitrarily through
points, google the groups for 'Dave Braden' and 'cubic spline', or go to Brian
Murphy's site, and look for the Excel Stuff link, which includes a treatment of the
bezier function used by Excel to draw this curve:

http://xlrotor.com

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

wrote:

i've set up a callibration curve in excel, I have experimental x values and
want to obtain the corresponding y values without using FORECAST, TREND tec.
any ideas?