The LOG10 function returns the logarithm of a number to the base 10.
This function is widely used in mathematics, physics, and statistics.
Syntax
LOG10(value)
Argument |
Description |
Permitted values |
|---|---|---|
value |
The number for which the logarithm to base 10 is calculated |
Any positive number or reference to a cell containing a number |
Examples of use
Calculating the decimal logarithm for the value of 100
=LOG10(100)
Result: 2, since log10 (100)=2.
Calculating the decimal logarithm for the value of 1000
=LOG10(1000)
Result: 3, since log10 (1000)=3.
Calculating the decimal logarithm for the value of 3
=LOG10(3)
Result: approximately 0.477.
Notes
The LOG10 function is undefined for zero or negative numbers. If you try to calculate the logarithm for such values, the result will be the #NUM! error.