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

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

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