Linear Interpolation in MS Excel

Shows how to set up a cell to automatically do linear interpolation in Microsoft Excel.

[egeakcay]

Hello, I am a naval architecture and marine engineering student and this video has saved me such a big time and energy i cant show you how greatfull i am. Thank you :)

[rhtocux]

Man, you're a life saver.
I'm working with people from JP Morgan and they used this Interpolation to determine interest rates.
I tried to do this what you explained and I got the same values as they did.
Thanks again!

[dhvanitmehta]

Saved my time and energy. Far better videos than others for linear interpolation.

[emmanuelekwu]

This is the most wonderful video i have ever watched on youtube. You just made my modeling so easy

[nathaliacarpio]

Thank you. Thank you. Thank you! Concise, clear, and so so so helpful!

[emreaskinelibol]

There are some errors. It should be as shown below:

For Xupper:=INDEX($A$5:$A$25, MATCH(K5, A$5:$A$25)+1)
For Yupper: =INDEX($B$5:$B$25, MATCH(M5, $B$5:$B$25, -1)+1)

For your information.

[glennfigueroa]

I don't know why i didnt get the same result in match function, but i tried xmatch then it works. Thanks!

[himanshu]

Thank you so much. It's works very well.

[heddo]

valuable information. Thank you appreciated

[muhammadirfan]

Bundle of thanks sir. It was really helpful.

[syazwanizakaria]

Thank you so much sir. that was very easy to do interpolation.

[Kail-bpye]

This may be a silly question, but is it possible to linearly interpolate negative values as well? I'm just beginning to learn this now on my own for a research project and so am not super familiar with this process

[choukster]

Thanks
I need to know how to deal with double interpretation

[snehalukey]

Hello, As my 1st Y value is zero, I am not able to get Yupper value with the formula used

[Elitecataphract]

What's wrong with Forecast.Linear?

[armandormita]

Good day sir. I follow your formula and its work. But how about if i have a(11.798, 15.055), b(18.326, 22.639), c(24.848, 30.229). I have also known d(18.666, 16.059). Now i want to know the foot perpindicular to the line w/c AB using your formula but the outcome is not match..can you help me sir.thanks

[JAWSFREE]

I was with you until 8:13, How did you move the formula without manually changing the rows? I thought you might be cutting and pasting but I got lost here.

[jackmatthews]

OMG i'll just calculate it by hand

[geetopriyoroy]

People who are watching this video, know the meaning of interpolation. They just came here to know the excel trick. So, don't elongate the video unnecessary by talking about the details of interpolation. Just stick to the point and come directly to the excel function that is required. 10 minutes for this simple trick is useless.