How to Use the Inverse Log Function in Excel

Written by ken burnside Google
  • Share
  • Tweet
  • Share
  • Email

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.

Skill level:
Easy

Other People Are Reading

Instructions

  1. 1

    Start Excel.

  2. 2

    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.

  3. 3

    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."

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

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