linear interpolation

[MetLife]

Hi,

I have a vba program, and need to do linear interpolation.

There is are x and y values, but the values are not always the same so I need to have some function or Sub routine.

I looked on the internet but couldn't find anything. It would be nice to use a custom program rather than a applicaiton.worksheetfunction() solution

Thanks

 

[Joe4]

Have a look here: http://www.engineerexcel.com/linear-interpolation-vba-function-in-excel/

 

[MetLife]

Thank you!

 

[MetLife]

Do you know why microsoft does not compile a list of functions for common things like linear interpolation?

This doesn't seem that hard to do.

 

[Joe4]

Do you know why microsoft does not compile a list of functions for common things like linear interpolation?

No. I don't work for MicroSoft, so I really cannot say.