Posted By

jimfred on 03/04/09


interpolation excel extapolation interpolate extrapolate

Versions (?)

Interpolation in Excel using =TREND (interpolate)

 / 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.

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

Report this snippet  

You need to login to post a comment.