Return to Snippet

Revision: 12168
at March 7, 2012 14:51 by jimfred


Updated Code
=TREND({0,100},{32,212},70)

In Open Office Calc...
=TREND({0;100};{32;212};70)

Revision: 12167
at March 4, 2009 14:44 by jimfred


Initial Code
=TREND({0,100},{32,212},70)

Initial URL
http://www.ozgrid.com/forum/showthread.php?t=69973

Initial Description
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.

Initial Title
Interpolation in Excel using =TREND (interpolate)

Initial Tags
excel

Initial Language
Other