DISCOVER
×

How to Use the Inverse Log Function in Excel

Updated April 17, 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."

Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Ken Burnside has been writing freelance since 1990, contributing to publications as diverse as "Pyramid" and "Training & Simulations Journal." A Microsoft MVP in Excel, he holds a Bachelor of Arts in English from the University of Alaska. He won the Origins Award for Attack Vector: Tactical, a board game about space combat.