Returns the logarithm of a number to the base you specify.
|number||The positive number for which you want the logarithm.|
|base||The base of the logarithm. If omitted, the base is 10.|
A decimal number.
You might receive an error if the value is too large to be displayed.
The function LOG10 is similar, but always returns the common logarithm, meaning the logarithm for the base 10.
The following formulas return the same result, 2.
=LOG(100,10) =LOG(100) =LOG10(100)