Excel - Cardinal spline function (UDF)

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 635 times)


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.