This tip was printed from the Tips for Spreadsheets website at http://tipsforspreadsheets.com/.

Microsoft Excel 2003 Functions and Formulas - Logarithmic Functions

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.