MS Excel: Log10 Function
In Excel, the Log10 function returns the base-10 logarithm of a number.
The syntax for the Log10 function is:
Log10( number )
number is a numeric value that must be greater than 0.
Applies To:
- Excel 2007, Excel 2003, Excel XP, Excel 2000
For Example:
Let's take a look at an example:

Based on the Excel spreadsheet above:
=Log10(A1) would return 1.301029996 =Log10(A2) would return 1.397940009 =Log10(A3) would return 2 =Log10(200) would return 2.301029996