Microsoft KB Archive/50453

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 19:24, 12 August 2020 by X010 (talk | contribs) (X010 moved page Microsoft KB Archive/Q50453 to Microsoft KB Archive/50453 without leaving a redirect: Text replacement - "Microsoft KB Archive/Q" to "Microsoft KB Archive/")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Excel: Calculating the Inverse of a Logarithm PSS ID Number: Q50453 Article last modified on 02-26-1992 PSS database name: M_eXceL

1.x 2.20 3.00 | 2.x 3.00 | 2.20 2.21 3.00



In Microsoft Excel, the logarithm of a number can be calculated with the following formula:


where “n” is the base, “X” is the initial value.

Thus, to calculate the inverse logarithm of a number, simply raise the base to the power of the value returned by the LOG function, as follows


where “Y” is the logarithm of the number.

For example, the logarithm of 100 with the base of 10 gives the result of 2:


Thus, the inverse logarithm of 2 in the above example is as follows:


More Information:

There are two additional forms of LOG in Excel. LOG10 uses base 10 and is equivalent to using LOG(X,10). LN is the “natural log,” which uses base 2 and is equivalent to using LOG(X,2).

Additional reference words: 2.20 2.2 2.21 3.0 3.00 antilog

Copyright Microsoft Corporation 1992.