+ Reply to Thread
Results 1 to 2 of 2

modify the the bilinear UDF for extrapolation

  1. #1
    Registered User
    Join Date
    10-22-2009
    Location
    cairo egypt
    MS-Off Ver
    Excel 2003
    Posts
    17

    modify the the bilinear UDF for extrapolation

    there is an excellent UDF for bilinear interpolation in this link

    http://www.excelforum.com/excel-prog...rpolation.html

    but if if the x value for example is beyond or less than the max or min values in the table the function gives
    error value and in other version of the same function it gives ( x outside table extents)

    is there any possibility to overcome this limit, i mean to modify the macro to deal with these values and calculate also extrapolation.
    this off course with shg permission
    or any other solution to do so

    thanks

  2. #2
    Registered User
    Join Date
    10-22-2009
    Location
    cairo egypt
    MS-Off Ver
    Excel 2003
    Posts
    17

    Re: modify the the bilinear UDF for extrapolation

    where are you shg

+ 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