Exceljet

Quick, clean, and to the point

Excel LOG10 Function

Excel LOG10 function
Summary 
The Excel LOG10 function returns the base 10 logarithm of a number. For example, LOG10(100) returns 2, and LOG10(1000) returns 3.
Purpose 
Get the base-10 logarithm of a number
Return value 
The logarithm
Syntax 
=LOG10 (number)
Arguments 
  • number - Number for which you want the logarithm.
Usage notes 

The LOG function allows you to get the base 10 logarithm of a positive number. For example:

=LOG10(100) // returns 2
=LOG10(1000) // returns 3
=LOG10(0.1) // returns -1
Related functions 
Excel LOG function
Excel LOG Function

The Excel LOG function returns the logarithm of a given number, using a supplied base. The base argument defaults to 10 if not supplied.

Excel POWER function
Excel POWER Function

The Excel POWER function returns a number to a given power. The POWER function works like an exponent in a standard math equation.

500 Formula Examples, thoughtfully explained.