Home

Microsoft Excel [email protected]

Microsoft Excel 2007

Microsoft Excel 2003

Forums

Microsoft Excel 2003 Functions and Formulas

Logarithmic Functions

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.

Print this tip.

- Subscribe!

Search the Site: