How to Use the Inverse Log Function in Excel

Written by ken burnside | 13/05/2017

A logarithm is the exponent of a mathematical equation. For example, in base 2, log 3 = 8. The inverse logarithm expresses that relationship as 2 raised to the third power equals 8. Excel uses this latter convention to generate inverse logarithm functions, but has no dedicated inverse log functions of its own.

Start Excel.

Generate the inverse of a common -- base 10 -- logarithm in cell "A1" by typing "=POWER(10,B1)" and entering the logarithm desired in cell "B1." You can replace the first 10 inside the parentheses with any base you choose.

Generate the inverse of a natural logarithm -- base 2.8172 -- in cell "A2" by typing "=EXP(B2)" and entering the logarithm desired in cell "B2."

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.