I am having some difficulty coming up with the excel version of the following function:
f(x) = (T1 - T0)L0 + (T2-T1)L1 + (T3 - T2)L2 + ... + (x - Tn)Ln
Constraints:
T0=0
Tk-1<=Tk
Tn<= x <= Tn+1
Tn and Ln reside in a couple of columns.
n is variable. Both as a number of entries and as an argument to the function.
How would I translate this to an excel cell?
Bookmarks