linear interpolation

Dear Excel friends, I want to linearly interpolate between multiple points. I have a column with values and empty cells. The values are not equidistant from each other. Excel allows me to linearly interpolate between two values using Fill>Series... , however, when I select multiple values it...

Hi all, I am having some issues with the following problem. I have a range of coordinates x [m] and 5 items defined by the functions x1,y1, x2,y2, x3,y3 and x4,y4. My objective is to find the y [mm2] value corresponding to my x-value by finding the value inside of my x1-x4,y1-y4 list. I need...

Hi, I have a table which i need to interpolate a range within two variables. On the top row is density which steps up 000.1 each time. On the far left column is temperature which consists of different steps eg. 7 7.1 7.2 then 7.25 7.3 7.4 and so on I need to find the value of a specific...

Sorry for the confusing title, essentially what I am trying to accomplish is creating the VBA for the excel ceiling_math function so I can use it in a linear interpolation function I am creating. I would like to figure out the code to allow the unitcount and significance in this code (bolded) to...

If my title caught your attention, please read further. I am not looking for elegance, but I am looking for a fast way to go through the data. I have 19914 lines (yes 19914 rows) of data that are separated into 3 columns Column A: Known Depth Column B: Known Age Column C: Known Depth (but points...

Here are 4 tables of iterated values for bottom hole pressures in CO2 injection wells. I’d like to be able to input a Surface Pressure (Psurf), TD (total depth), average fluid temperature Tavg, and CO2% and have excel go find the best approximation of the bottom hole pressure from the tables...

Hi All I am using Vlookup formula, but the second column of data (the data which vlookup returns) is very noisy, and instead of choosing the nearest datapoint I would rather do a linear interpolation between the nearest 2 datapoints... What is the easiest way to do this? Many thanks in...

I have to calculate interest rates for dates between posted dates My bank has given me the following. The rate on 05/17/2017 is 3.7973%. The rate on 08/15/2017 is 3.7235%. The requested date is 07/15/2017 and the bank interpolated the rate to 3.7482%. I need a formula where I have three...