Natural Log Function ( LN )

  • Thread starter Thread starter Kit Truong
  • Start date Start date
K

Kit Truong

Hello,

I'm using Access 2000 and I'm trying to use the natural logarithm function
( ln ) in one of my modules but one doesn't exist.

Does anyone know or have a function that uses the existing Math.log/exp
functions to get the equivalent ln function?

Thanks.
 
VBA's Log function is the natural logarithm.

From ACCESS Help File:

Log Function
Returns a Double specifying the natural logarithm of a number.

Syntax
Log(number)

The required number argument is a Double or any valid numeric expression
greater than zero.

Remarks
The natural logarithm is the logarithm to the base e. The constant e is
approximately 2.718282.
You can calculate base-n logarithms for any number x by dividing the
natural logarithm of x by the natural logarithm of n as follows:
Logn(x) = Log(x) / Log(n)

The following example illustrates a custom Function that calculates
base-10 logarithms:
Static Function Log10(X)
Log10 = Log(X) / Log(10#)
End Function
 
Back
Top