LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
aj4444
 
Posts: n/a
Default Linear interpolation between two points found using a lookup funct

I need to interpolate two points (x0,y0) & (x1,y1) to find the y value for a
given x. First, I need to find x0 and x1 from a column using a lookup
function. The x's column increases as you go down.

For example given a data set:

x's y's
20.33 5
22.69 7
25.06 8
27.42 18
29.79 37

Say I want to find y for x=23. I want to lookup the two closest values of
x's that x=23 is between(22.69 and 25.06) and then use these two points to
linearly interpolate the y for x=23. Any suggestions?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
linear interpolation function in excel tskoglund Excel Worksheet Functions 4 September 10th 05 03:31 AM
I am looking for a function for linear interpolation azad Excel Discussion (Misc queries) 1 July 17th 05 09:18 PM
Lookup returns message box when an exact match is not found JFeeman Excel Worksheet Functions 3 February 11th 05 07:19 PM
linear interpolation Taha Excel Discussion (Misc queries) 3 January 31st 05 02:12 PM
double lookup, nest, or macro? Josef.angel Excel Worksheet Functions 1 October 29th 04 09:50 AM


All times are GMT +1. The time now is 11:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"