Name

LOG

Synopsis

You can use LOG to determine the logarithm of a number to any base. By default, the function assumes you want to determine the base-10 logarithm for the specified numeric value; to use a different base you must specify a value for the Base argument.

To Calculate

=LOG(Number, Base)

The Number argument is required and must have a positive value. The Base argument is optional.

Number

Indicates the positive numeric value for which you want to determine the logarithm.

Base

This optional argument specifies the base you want to use for the logarithm. The value of this argument must be a positive numeric value. If this value is omitted, the function assumes you want to find a base-10 logarithm of the value specified for the Number argument.

Example

Figure 14-12 illustrates the difference between using LOG to find the log to a specific base and using LOG10 to find the base 10 log. The example also shows how POWER is used to determine the value of raising a number to a specific power.

LOG finds the log of a number to the specified base; whereas, LOG10 finds the log for a number to the base of 10

Figure 14-12. LOG finds the log of a number to the specified base; whereas, LOG10 finds the log for a number to the base of 10

Get Excel 2000 in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.