custom function
Does anyone have any code (or at least enough to get me started) to perform
a linear interpolation of points? I want something with the following
inputs...
Point 1: 12
Value 1: 2.000
Point 2: 24
Value 2: 1.000
Desired Point: 15
Round: 3
Output would be 1.750
Formula would be as follows:
{(Value 1 - Value 2) x [(Point 2 - Desired Point)/(Point 2 - Point 1)]} +
Value 2
Thanks!!
Dave
|