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
Summary:
In Microsoft Excel, the logarithm of a number can be calculated with the following formula:
=LOG(X,n)
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
=n^Y
where “Y” is the logarithm of the number.
For example, the logarithm of 100 with the base of 10 gives the result of 2:
LOG(100,10)=2
Thus, the inverse logarithm of 2 in the above example is as follows:
10^2=100
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.