Summary: Perform natural, base-10, and base-n log functions in Excel 2003 spreadsheets.
If you need to perform logarithmic functions in a Microsoft Excel 2003 spreadsheet, the following may be useful:
=ln(NUMBER)
Returns the natural log of NUMBER.
=log(NUMBER,BASE)
Returns the log of NUMBER to the designated BASE.
=log10(NUMBER)
Returns the base-10 log of NUMBER.
Assume the following spreadsheet:
A1: =ln(3.787)
A2: =log(900,30)
A3: =log10100)
This will return the values:
A1: 1.999722 (approximated)
A2: 2
A3: 2
Add: Del.icio.us |
Digg |
Furl |
My Yahoo!
Last Modified on: July 13, 2008, at 12:04 A.M. EDT
Return to the Microsoft Excel 2003 Functions and Formulas page.
Search the Site: