Linear Interpolation
I'm currently in college as a Civil Engineer. I do a lot of spreadsheets that requires linear interpolation using arrays. I've been trying to work on a workbook function that will see the number that I'm looking at, find that number between two others, and then report back to me the vlookup value associated with that interpolation. I have attached my workbook (note: this is only an example of what I would like to be done and not a hmwk problem). For example I would like to input =interpolation(2.5,B4: D14,3)------- (=interpolation(number_used_to_interpolate, array_to_look_from, col_index_answer) to give me an answer of 0.875.
Thanks for your help
Reply With Quote