In article , ?B?SGVscCEhISEh?= wrote:
I was trying to interpolate numbers by using Forecast, but it is not the
linear interpolation result I need. I am wondering is there a way to do it?

Following is Forecast help example. By using Forecast, the result is 10.6,
but if using interpolation, Known Y (7,9) Known X (28,31), the result should
be 8.333

Known Y KnownX
6 20
7 28
9 31
15 38
21 40
Formula Description (Result)
=FORECAST(30,A2:A6,B2:B6) Predicts a value for y given an x value of 30
(10.60725)

Thank you very much in advance !!!!!!

You could use the slope and intercept functions and calculate the numbers
you ned using those. That way the function doesn't get in the way of what
you are trying to do :)


Bruce

----------------------------------------
I believe you find life such a problem because you think there are the good
people and the bad people. You're wrong, of course. There are, always and
only, the bad people, but some of them are on opposite sides.

Lord Vetinari in Guards ! Guards ! - Terry Pratchett

Caution ===== followups may have been changed to relevant groups
(if there were any)