Interpolate X

[justmcd]

Hi

I have create a worksheet where I am able interpolate Yif X is known. However I am also battling to do the reverse where Y is known and interpolate X. See attached.

Your assistance will be highly appreciated.

Regards

[tommyt61]

http://peltiertech.com/WordPress/excel-interpolation-formulas/ (http://peltiertech.com/WordPress/excel-interpolation-formulas/)


This should be just what you are looking for.