The information in this article applies to:
SUMMARYMicrosoft Excel has built-in functions to calculate the logarithm of a number with a specified base, the logarithm with base 10, and the natural logarithm. To calculate the inverse log of a number in the first two cases, raise the base to the power of the value returned by the particular logarithm function being used. To find the inverse natural log, use the EXP function. MORE INFORMATION
You can formulas in the following table to perform logarithmic and inverse
log operations.
NOTE: In the above table, "n" is a variable that is either a value or the address of a cell containing a value, "b" (in the first function) is the base with which the logarithm is calculated, and "x" is a variable representing the result of the log function being used. NOTE: Unless a different value or cell address is specified, the default value for the base is 10. REFERENCES"Microsoft Excel Function Reference," version 3.0, pages 72, 143-144 Additional query words: 2.0 2.00 2.01 2.1 2.10 2.2 2.20 2.21 3.0 revlog log10 arc Anti AntiLog anti-log 8.00
Keywords : |
Last Reviewed: July 23, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |