Calculate an Interpolated Value.

Category:
Dates and Math
Type:
Snippets
Difficulty:
Intermediate
Author:
Martin Wallace

Version 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:

Code: