Missing function

[Mr930]

I inherited a spreadsheet that calls a function named INTERP(). I have opened this in Excel 2007 and had no trouble, but in 2010 I get #NAME. I assumed there was some sort of add-in that was missing. An internet search produced no solid results other than there are a lot of custom functions floating around called INTERP(). The funny thing is, on my PC with Office 2007, there are NO add-ins active at all and it works. So I am wondering how this can work in one version of Excel and not another? Has anybody come across INTERP() before?

thanks
Fred Emmerich

 

[Mr930]

I did a full recalc, no luck. I'll try and step through the code, it is a huge file with multiple calls to the missing function.

 

[shg]

In 2007 (the version that works), select any cell and paste INTERP into the Names box (left of the formula bar). If it's a UDF, doing that will take you to the code.

 

[chenyu768]

Interp()=Interpolate

Does a lookup where it interpolates between results. The default is straight line interpolation, but it can do other forms, too.

<tbody style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-family: inherit; font-size: inherit; font-style: inherit; font-variant: inherit; line-height: inherit; vertical-align: baseline; width: 875px;">
</tbody>