Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extract from a table a value by interpolating
Hi,
I'm a new with fancy things in excell and would very much appreciate the help. I have a table from which I want to extract values, but I want those values to be interpolated from what is in the table. How can I do that? Thanks, Maria |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extract from a table a value by interpolating
hi, this is how i do it.
Lets say your table is at A12 to B20 make another column at column C with this equaition =(B14-B13)/(A14-A13) A B C 12 2.000 1.000 0.5 13 4.000 2.000 1.0 14 6.000 4.000 1.0 15 8.000 6.000 1.0 16 10.000 8.000 1.0 17 12.000 10.000 1.0 18 14.000 12.000 1.0 19 16.000 14.000 1.0 20 18.000 16.000 1.0 Your original value which you need to interpolate from the table, put it in F8 in F9 (or where you want your interpolated value to shop up) put this equation below. =VLOOKUP(F8,$A$12:$D$20,2)+VLOOKUP(F8,$A$12:$D$20, 3)*(F8-VLOOKUP(F8,$A$12:$D$20,1)) this should work. works for me, let me know any prob. Raz "Maria" wrote: Hi, I'm a new with fancy things in excell and would very much appreciate the help. I have a table from which I want to extract values, but I want those values to be interpolated from what is in the table. How can I do that? Thanks, Maria |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Interpolating between two points | Excel Discussion (Misc queries) | |||
Interpolating an x, y point from known x's and y's | Excel Worksheet Functions | |||
Interpolating an x, y point from known x's and y's | Charts and Charting in Excel | |||
Filter records in a table to extract to another table | Excel Discussion (Misc queries) | |||
Help with Interpolating for a value. | Excel Worksheet Functions |