Export (0) Print
Expand All

LOG Function

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

LOG(<number>,<base>)

Term

Definition

number

The positive number for which you want the logarithm.

base

The base of the logarithm. If omitted, the base is 10.

A decimal number.

You might receive an error if the value is too large to be displayed.

The function LOG10 is similar, but always returns the common logarithm, meaning the logarithm for the base 10.

The following formulas return the same result, 2.

=LOG(100,10)
=LOG(100)
=LOG10(100)
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft