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.

Examples

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)

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Any additional feedback? (Optional)

Thank you for your feedback!

×