Log Function

Returns a Double specifying the natural logarithm of a number.

Syntax

Log(num)

The required num argument is a Double or any valid numeric expression greater than zero. If this argument is a non-initialized variable, or Null, an error occurs.

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:

Log n(x) = Log(x) / Log(n)

Example

The following example illustrates a custom Function that calculates base-10 logarithms:

Function Log10(X)
Log10 = Log(X) / Log(10)
End Function

 

See Also

Exp Function