Results 1 to 9 of 9

2D Interpolation in Excel

Threaded View

  1. #1
    Registered User
    Join Date
    01-27-2016
    Location
    India
    MS-Off Ver
    2010
    Posts
    4

    2D Interpolation in Excel

    I have a table like this (2D Table)::
    ================================

    D1 L1 Values
    ==================
    0.1 - 1 - 0.050
    0.1 - 2 - 0.055
    0.1 - 3 - 0.090
    0.4 - 1 - 0.060
    0.4 - 2 - 0.072
    0.4 - 3 - 0.099
    0.7 - 1 - 1.0
    0.7 - 2 - 1.1
    0.7 - 3 - 2.0
    2.9 - 1 - 4.0
    2.9 - 2 - 5.2
    2.9 - 3 - 7.0


    Now I need to find a value at D1=1.5 & L1=2 point, can anyone give me a solution to do in excel?
    The table which is plotted is arbitrary but in actual case it might be monotonous in nature. But linear extrapolation will be good enough to find the desired value for D1 and L1 point.
    Last edited by anirbanphys; 01-27-2016 at 07:11 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Interpolation in excel with VBA
    By john.smidth in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-26-2012, 01:01 AM
  2. Interpolation in Excel
    By Gio_it in forum Excel General
    Replies: 2
    Last Post: 02-23-2011, 12:01 PM
  3. Excel 2007 : Interpolation in excel
    By gannon_w in forum Excel General
    Replies: 3
    Last Post: 01-14-2010, 07:41 PM
  4. Replies: 0
    Last Post: 07-24-2008, 02:27 PM
  5. Interpolation in EXCEL
    By bg_nj in forum Excel General
    Replies: 1
    Last Post: 02-27-2008, 03:26 PM
  6. Need help with Interpolation in Excel
    By uwresearch in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-18-2007, 04:26 AM
  7. help with interpolation and limit of interpolation
    By uriel78 in forum Excel General
    Replies: 0
    Last Post: 02-18-2005, 10:06 AM
  8. interpolation in excel
    By Elif in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-07-2005, 07:06 AM

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