Excel - Cardinal spline function

If you want to create a curve that goes exactly through all your data points, you can use a spline. The demo file contains a Cardinal Spline function (UDF).

Option 1: Regular functions


Option 2: Array function


     Download demo file  (63kB - downloaded 860 times)



Remark

MS Excel VBA code to be put in a module

In MS Excel, press Alt+F11 to open the Visual Basic Editor (Windows). Via top menu: Insert → Module. Copy the MS Excel VBA code of the functions into the module.