LOG

Microsoft Datasheet View

LOG

Returns the logarithm of a number to the base you specify.

Syntax

LOG(number,base)

Number    is the positive real number for which you want the logarithm.

Base    is the base of the logarithm. If base is omitted, it is assumed to be 10.

Example

Formula Description (Result)
=LOG(10) Logarithm of 10 (1)
=LOG(8, 2) Logarithm of 8 with base 2 (3)
=LOG(86, 2.7182818) Logarithm of 86 with base e (4.454347)