| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Interpolation within a data table
Hello,
TREND is IMHO not the right way to go. If, for example, you would have A values of -1,000,000 for the points 6.5 and 6.8 then TREND through all points 6.5, ..., 6.8 would result in -493,126 for the three points 6.6, 6.67 and 6.7. If I understood you correctly you were looking for an interpolation. My formula is giving you exactly that. An interpolation UDF you can find he http://www.sulprobil.com/html/interpolate.html Regards, Bernd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to do linear interpolation between entries in lookup table | Excel Discussion (Misc queries) | |||
| Find a Value by interpolation from a table of x and y values | Excel Worksheet Functions | |||
| Interpolate, Interpolation, VlookUp, HlookUp, Read a table | Excel Worksheet Functions | |||
| help with interpolation and limit of interpolation | Excel Discussion (Misc queries) | |||
| interpolation XY data with bezier curver | Charts and Charting in Excel | |||
Threaded Mode
