What is this and where from i found its Syntax

[hamadsultan]

Hi Experts;
I have a excell sheet in which i see the following line in the formula bar;
=If(G15=0,SInterp2(c13,81,11,FLTAMB,OPTDATA,10,1), SInterp2(c13,81,11,j69,E52,j73,20,9))
I search help but nothing found.
How can i understand this? i need a syntax how many parameters are passed to Sinterp2?
Reagrds

 

[mvptomlinson]

In your example, the first call to SInterp2 has 7 parameters and the second call has 8. So there are obviously optional parameters, but no way to tell from the formula how many exactly.

You would need to see the actual function code in the VB Editor to determine that. (Or try throwing it more and more parameters until it fails, perhaps)

 

[hamadsultan]

Hi;
is it user defined function? in vb code or built in excell function?

 

[mvptomlinson]

It is not a built-in function or vb function. Since you're using it in a cell in a worksheet, and it's not built-in, it is therefore a user-defined function and likely exists within a standard code module within the workbook or in an add-in.