Microsoft KB Archive/50453
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
MACINTOSH | WINDOWS | OS/2
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:
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.