+ Reply to Thread
Results 1 to 3 of 3

Linear interpolation between just two points

  1. #1
    Registered User
    Join Date
    09-06-2011
    Location
    Oz
    MS-Off Ver
    Excel 2003
    Posts
    3

    Linear interpolation between just two points

    Hi All,

    I've found plenty of articles about linear interpolation, but i'm having trouble getting the indexing part right. My data looks like this:

    A, B, C
    1-Jan-2000, 100
    1-Feb-2000
    1-Mar-2000
    1-Apr-2000, 130
    1-May-2000
    1-Jun-2000
    1-Jul-2000, 100

    I'm after a formula that I can put in C that will return the value in B if it's a number, or otherwise, interpolate between the two nearest points above and below. So, the formula would return:

    100
    110
    120
    130
    120
    110
    100

    Any help much appreciated. Actual data set attached.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    07-29-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2003/Excel 2010
    Posts
    534

    Re: Linear interpolation between just two points

    Is this what you're looking for?
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-06-2011
    Location
    Oz
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Linear interpolation between just two points

    Good man. That'll do the job.

    Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1