Run-time error, why?

[Guest]

I have this line in my macro:
k = Log(Atn(x) * Sin(5 * x)) / Log(Cells(3, "L"))
But it gives me an error.

I can't figure out, why. Any ideas?

 

[Don Guillett]

I know next to nothing about scientific functions but the vba help index for
LOG showsmy guess isk = Log(Atn(x) * Sin(5 * x)) / Log(Cells(3, "L"))k =
(Log(Atn(x)) * Sin(5 * x)) / Log(Cells(3, "L"))Static Function Log10(X)
Log10 = Log(X) / Log(10#)
End Function

 

[Art H]

Might you be taking the log of a number that is negative or is equal to
zero?

Test the individual components of the expression to determine
intermediate results.

Art