Help with Interpolation
Posted by Patrick Kilgore on March 15, 2001 12:23 PM
I have a worksheet that calculates stability parameters for a ship based on the amount of water stored in the ship's ballast tanks. I would like to create a function that will read the water level in a tank from this sheet and return quantities such as volume and weight of the water in the tank. The function would read water level and volume data stored in other worksheets, interpolate based on water level, and write the result to the original sheet. My question is this: How do you tell Excel to look for the two values to interpolate between? Once Excel finds the two tank levels on the data sheet that most closely bracket the tank level of interest on the original sheet, interpolating results should be fairly straightforward.