Thread: custom function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dave!! dave!! is offline
external usenet poster
 
Posts: 10
Default 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