How do I extract data from graph (i.e. interpolaton)
FORECAST() both forecasts and interpolates:
In A1:B2 put:
2200 1.21
2400 1.37
anywhere else put =FORECAST(2217,B1:B2,A1:A2) and you will see: 1.22360
--
Gary's Student
"TauBrewer" wrote:
If we have a table of data values, can we build a graph and extract values
from it not found in the table?
Example pairs 2200, 1,21; 2400, 1.37 are in table from which a (non-linear)
graph is created. Is there any simple way to find the value that goes with
2217, for example?
I know we can use match and index and do linear interpolation, but is there
a simpler or more elegant way to do this?
|