Related Function:

The LOG10 function returns the base-10 logarithm of a number.

Syntax

=LOG10(number)

Arguments

Argument Description
number The positive real number for which you want the base-10 logarithm

Examples

  A B C D
1 Formula Result Notes Description
2 =LOG10(10) 1 The power 10 is raised to to equal 10 101 = 10; therefore, log10(10) = 1
3 =LOG10(100) 2 The power 10 is raised to to equal 100 102 = 100; therefore, log10(100) = 2
4 =LOG10(1000) 3 The power 10 is raised to to equal 1000 103 = 1000; therefore, log10(1000) = 3
5 =LOG10(86) 1.9345 The power 10 is raised to to equal 86 101.9345 = 86; therefore, 1010(86) = 1.9345
6 =LOG10(0.001) -3 The power 10 is raised to to equal 0.001 10-3 = 0.001; Therefore, Log10(0.001) = -3

Common Function Error(s)

Problem What went wrong
#NUM! Occurs if the supplied number argument is negative or zero
#NAME? Occurs if the supplied number argument is not a numeric value

The logarithm of a number, to a given base, is the power to which the base must be raised to give that number.

The base 10 logarithm, or common logarithm, is written as log_{10}(x). Therefore, if  

10^x = y

then

log_{10}(y) = x

See Wikipedia for more information on logarithm and common logarithm.