Excel Tools

Various tools in MS Excel, with full documentation

Bilinear Interpolation - Two independent variables

v2.00 (Release date: March 19, 2024), Available in English.

In mathematics, bilinear interpolation is an extension of linear interpolation for interpolating functions of two variables (e.g., x and y) on a rectilinear 2D grid. The key idea is to perform linear interpolation first in one direction, and then again in the other direction. Although each step is linear in the sampled values and in the position, the interpolation as a whole is not linear but rather quadratic in the sample location. Read more on Wikipedia

Download File (xlsx)