Returns the natural logarithm of a number.
Syntax Log (Number) Key number Any valid numeric expression greater than 0.
The Log() function can be used in VBA or in an SQL query.
The natural logarithm is the logarithm to the base e. The constant e is approximately 2.718282.
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)
A custom Function to calculate base-10 logarithms:
Function Log10(X)
Log10 = Log(X) / Log(10)
End Function
“Gold is the money of kings; silver is the money of gentlemen; barter is the money of peasants; but debt is the money of slaves” ~ Norm Franz
Related:
Exp(n) - Return e (base of natural logs) raised to a power n.