Linear Interpolation in Excel

[adelkam]

Hi,

I could perform a linear interpolation for data represented in X & Y.

It works fine except for one limitation, which is that it provides only one value, while the data could have 2 possible values.

I appreciate any help in modifying the formula to work as intended... Sample file is attached Thanks

[AliGW]

Is this the same as your other thread?

https://www.excelforum.com/excel-for...rpolation.html

If so, this duplicate will be closed.

[Bo_Ry]

Please try

=FORECAST(F2,LARGE(C2:C11,MATCH(F2,B2:B11,1)+{0;1}),SMALL(B2:B11,MATCH(F2,B2:B11,1)+{0;1}))
and
=FORECAST(F2,LARGE(C11:C20,MATCH(F2,B11:B20,-1)+{0;1}),LARGE(B11:B20,MATCH(F2,B11:B20,-1)+{0;1}))

confirm with Ctrl+Shift+Enter

[adelkam]

@AliGW
No it is not the same... It is completely different problem!

[adelkam]

Thanks Bo_Ry!

It works excellent with 99% of the cases, except for two minor things:

- If I try with "0", I get only one value, and error in the other

- I see the formulas is hard coded for two ranges within the dataset; 2:11, and 11:20 presumably because row 11 is happened to be the pivot point. Can we avoid this, and make the formulas to work dataset size specifying the range?

Thanks again, and really appreciated your help!

[Bo_Ry]

Try

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[adelkam]

Thanks Bo_Ry... works great!