ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Interpolate, Interpolation, VlookUp, HlookUp, Read a table (https://www.excelbanter.com/excel-worksheet-functions/108303-interpolate-interpolation-vlookup-hlookup-read-table.html)

cradino

Interpolate, Interpolation, VlookUp, HlookUp, Read a table
 
As described by MsShorty: Sometimes when you have a
table of data, it is easier/preferable to approximate the function as a
series of straight lines connecting the data points (similar to what a
line chart/XY chart does) rather than attempt to fit the data to a
curve.
...............................

These problem are solved by PUP6 - Power Utilities 6 at
http://www.j-walk.com/ss by $35 as a multiple add-ins to Excel, very usefull
that I bought.
I advise the purchase animatedly!


All times are GMT +1. The time now is 02:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com