View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AG[_4_] AG[_4_] is offline
external usenet poster
 
Posts: 5
Default writing its own function

Hi all,

I am writing this function to be used in a sheet :

Function my_erf(x)
If (Abs(x) 27) Then
my_erf = 1
Else
my_erf = sign(x)*erf(abs(x))
End If
End Function


I put it inside a modul. I have two moduls : one for my macros, and one
for this function.

When I try to use the function, I get the message that the sign()
function is unknown, and the same for the erf() function, which I can
both use in my sheet.

I don't understand why, and how I can solve this.

Thanks,

Alexandre.