Log returns a double-precision value equal to the natural logarithm of a number. The required parameter, number, is any numeric expression. The natural logarithm is the base e logarithm; e is approximately equal to 2.718282.
Calculating base-n logarithm of x is achieved by dividing the natural logarithm of x by the natural logarithm of n.
Rem Log Example 'Log calculates natural logarithms Dim e e = 2.718282 Print "Log(1) = " & Log(1) Print "Log(e) = " & Log(e) Print "Log10(2) = " & LogN(10, 2) Function LogN(Base, Number) LogN = LOG(Number) / LOG(Base) End Function
LOG(1) = 0 LOG(e) = 1 LOG10(2) = 0.30103