Advanced Search

Interpolation in Excel using =TREND (interpolate)

/ Published in: Other
Save to your folder(s)
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.

Expand | Embed | Plain Text

Copy this code and paste it in your HTML 
  1. =TREND({0,100},{32,212},70)
  2.  
  3. In Open Office Calc...
  4. =TREND({0;100};{32;212};70)

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

Report this snippet


Comments

RSS Icon Subscribe to comments

You need to login to post a comment.