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
Press the "print" button on your browser or select "File" - "Print" to print this tip. Then, return to Microsoft Excel 2003 Functions and Formulas - Logarithmic Functions.
Standard disclaimer applies - Read http://tipsforspreadsheets.com/copyright-disclaim.html.