Finding Value with Nearest Interpolation

An Excel file that teaches how to perform Finding Value with Nearest Interpolation operation.

Excel Finding Value with Nearest Interpolation

Data points are plotted on the table. Interval calculations are performed using a formula. Intermediate values are found using a linear relationship. Errors are controlled within the tolerance margin. Prediction results are visualized.

Hope it is useful.