Advanced Search

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