LOG

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 given base.

  • 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.

Examples