Saturday, May 19, 2012

How to Use the Inverse Log Function in Excel


1. Start Excel.
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. 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.'

Blogger news