Returns the logarithm of a number given a base.
Sample usage
LOG(128,2)
LOG(A2,3)
Syntax
LOG(value, [base])
-
value
- the value for which to calculate the logarithm givenbase
.value
must be positive.
-
base
- [10 by default] the base to use for calculation of the logarithm.
See also
SQRTPI
: Returns the positive square root of the product of Pi and the given positive number.
SQRT
: Returns the positive square root of a positive number.
POWER
: Returns a number raised to a power.
LOG10
: Returns the logarithm of a number, base 10.
LN
: Returns the logarithm of a number, base e (Euler's number).
GAMMALN
: Returns the logarithm of a specified gamma function, base e (Euler's number).
EXP
: Returns Euler's number, e (~2.718) raised to a power.