The LOG10 function returns the base-10 logarithm of a number.
|number||The positive real number for which you want the base-10 logarithm|
|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 . Therefore, if