| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Custom Function | Excel Discussion (Misc queries) | |||
| Custom Function: Detecting the cell the function is used in | Excel Programming | |||
| Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
| custom function - with built-in function | Excel Programming | |||
| Adding a custom function to the default excel function list | Excel Programming | |||
Threaded Mode
