| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A value between 2 values
Hi, I have a lot of values in a table:
A B Area Price 34 1 50 1.2 60 1.3 70 1.5 80 1.5 90 1.6 100 1.7 .... ... I want to interpolate between two values so if the value of area is ex. 35 the computer will use my interpolation formula (y2=y3-(((y3-y1)*(x3-x2)/(x3-x1)))) with values 34,50 and 1,1.2 looking for the cost in the value area=35 I can't look up for the function because it's a non- linear graph and presition is needed so, ¿Any suggestions? TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A value between 2 values
Here are some past posts on this topic. You should be able to finde
something to help you out: http://tinyurl.com/9yrv2 -- Regards, Tom Ogilvy "filo666" wrote in message ... Hi, I have a lot of values in a table: A B Area Price 34 1 50 1.2 60 1.3 70 1.5 80 1.5 90 1.6 100 1.7 ... ... I want to interpolate between two values so if the value of area is ex. 35 the computer will use my interpolation formula (y2=y3-(((y3-y1)*(x3-x2)/(x3-x1)))) with values 34,50 and 1,1.2 looking for the cost in the value area=35 I can't look up for the function because it's a non- linear graph and presition is needed so, ¿Any suggestions? TIA |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
A value between 2 values
TankS TOM..
"Tom Ogilvy" wrote: Here are some past posts on this topic. You should be able to finde something to help you out: http://tinyurl.com/9yrv2 -- Regards, Tom Ogilvy "filo666" wrote in message ... Hi, I have a lot of values in a table: A B Area Price 34 1 50 1.2 60 1.3 70 1.5 80 1.5 90 1.6 100 1.7 ... ... I want to interpolate between two values so if the value of area is ex. 35 the computer will use my interpolation formula (y2=y3-(((y3-y1)*(x3-x2)/(x3-x1)))) with values 34,50 and 1,1.2 looking for the cost in the value area=35 I can't look up for the function because it's a non- linear graph and presition is needed so, ¿Any suggestions? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2007 doesnt show Y-axis values when the values are small. | Charts and Charting in Excel | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Search/Filter to find values in another range based on two cell values | Excel Programming | |||
| How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in | Excel Programming | |||
| Predict Y-values on new X-values based on other actual X and Y values? | Excel Programming | |||
Hybrid Mode
