LOG

Returns the logarithm of the specified number to the specified base.

Syntax

LOG( Number n, [Number base = 10] ) → Number

Parameters

n

Required. The number for which to find a logarithm. Must be a positive value.

base

Optional. The base of the logarithm. If omitted, base is assumed to be 10.

Remarks

Returns the logarithm of n in the specified base. If either n or base is negative or zero, the function returns the #NUM! error value.

Example

Formula

=LOG(100)
=LOG(16,2)

See Also

Function Reference
LOG10 Function
LN Function
POWER Function
EXP Function