Last modified: December 06, 2011
Applies to: Office 2013 | VBA
Returns a Double specifying the natural logarithm of a number.
Log( number )
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