linear interpolation

  1. N

    Linear Interpolation of a Table with two variables and different steps

    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...
  2. A

    VBA syntax for allowing the input of a cell to be equal to a variable value

    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...
  3. C

    Non linear but linear Interpolation

    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...
  4. J

    4 Linear Interpolations... I think.

    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...
  5. B

    is there an alternative to VLOOKUP which interpolates

    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...
  6. J

    linear interpolation

    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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top