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