Calculate an Interpolated Value.
Category:
Dates and MathType:
SnippetsDifficulty:
IntermediateAuthor:
Martin WallaceVersion Compatibility: Visual Basic 6, Visual Basic 5
More information:
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.
Declarations: