/ Published in: Other
This example demonstrates interpolation using Excel's =TREND function by converting 70 degrees F to 21 Celcius.
=TREND({0,100},{32,212},70)
The {..} arrays can of course be replaced with a cell range specifier.
=TREND({0,100},{32,212},70)
The {..} arrays can of course be replaced with a cell range specifier.
URL: http://www.ozgrid.com/forum/showthread.php?t=69973