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.
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.