Calculate an Interpolated Value.
Category:Dates and Math
Version Compatibility: Visual Basic 6, Visual Basic 5
This function will return a linear interpolated value. See comments for further information. eg: *------------+-----* a c b 1 3 5 10 x 50 To find x at c the correct syntax would be: x = Interpolate(1,10,5,50,3) and the answer would be 30 Passing a value of true (default) for boolExtrapolate will switch on extropolation if findindex falls outside the bounds of index1 and index2.
Instructions: Copy the declarations and code below and paste directly into your VB project.