How to Use Excel to Interpolate. Interpolation is a powerful tool used to determine values that do not appear within a given set of numbers. A business owner can take numbers concerning future ...

The following Microsoft Excel formula performs linear interpolation by calculating the interpolation step value: = (end-start)/ (ROW (end)-ROW (start)) where end is the cell address of the larger ...