I came across this and was reluctant to use an add-in because it makes it tough to share the sheet with people who don't have the add-in installed. My officemate designed a clean formula that is relatively compact (at the expensive of using a bit of magic). Things to note: • The formula works by: • using the MATCH function to find the row in the inputs range just before the value being searched for (e.g. 3 is the value just before 3.5) • using OFFSETs to select the square of that line and the next (in light purple) • using FORECAST to build a linear interpolation using just those two points, and getting the result • This formula cannot do extrapolations; make sure that your search value is between the endpoints (I do this in the example below by having extreme values). Not sure if this is too complicated for folks; but it had the benefit of being very portable (and simpler than many alternate solutions). If you want to copy-paste the formula, it is: =FORECAST(F3,OFFSET(inputs,MATCH(F3,inputs)-1,1,2,1),OFFSET(inputs,MATCH(F3,inputs)-1,0,2,1 ( inputs being a named range). A nice graphical way to see how well your interpolated results fit: Take your date,value pairs and graph them using the XY chart in Excel (not the Line chart).

Right-click on the resulting line on the graph and click 'Add trendline'. Behringer Xenyx X1222usb Driver Download. There are lots of different options to choose which type of curve fitting is used.

Then you can go to the properties of the newly created trendline and display the equation and the R-squared value. Make sure that when you format the trendline Equation label, you set the numerical format to have a high degree of precision, so that all of the significant digits of the equation constants are displayed. The answer above by YGA doesn't handle end of range cases where the desired X value is the same as the reference range's X value. Using the example given by YGA, the excel formula would return #DIV/0! Error if an interpolated value at 9999 was asked for. This is obviously part of the reason why YGA added the extreme endpoints of 9999 and -9999 to the input data range, and then assumes that all forecasted values are between these two numbers. If such padding is undesired or not possible, another way to avoid a #DIV/0!

Error is to check for an exact input value match using the following formula: =IF(ISNA(MATCH(F3,inputs,0)),FORECAST(F3,OFFSET(inputs,MATCH(F3,inputs)-1,1,2,1),OFFSET(inputs,MATCH(F3,inputs)-1,0,2,1)),OFFSET(inputs,MATCH(F3,inputs)-1,1,1,1)) where F3 is the value where interpolated results are wanted. Note: I would have just added this as a comment to the original YGA post, but I don't have enough reputation points yet. You can find out which formula fits best your data, using Excel's 'trend line' feature. Using that formula, you can calculate y for any x • Create linear scatter (XY) for it (Insert =>Scatter); • Create Polynominal or Moving Average trend line, check 'Display Equation on chart' (right-click on series =>Add Trend Line); • Copy the equation into cell and replace x's with your desired x value On screenshot below A12:A16 holds x's, B12:B16 holds y's, and C12 contains formula that calculates y for any x.

I first posted an answer, but later found this question.

The values of s are determined by cubic spline interpolation of x and y. Use spline to interpolate a sine curve over unevenly-spaced sample points. A tridiagonal linear system (possibly with several right-hand sides) is solved for the information needed to describe the coefficients of the various cubic polynomials that.