Documentation/Calc Functions/LOG10
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Function name:
LOG10
Category:
Mathematical
Summary:
Calculates the logarithm to the base 10 or common logarithm of a positive real number. The common logarithm of x is often written as log(x) or log10(x).
Syntax:
LOG10(Number)
Returns:
Returns a real number that is the common logarithm of the specified number.
Arguments:
Number is a positive real number, or a reference to a cell containing that number, that is the value for which the common logarithm is to be calculated.
- If Number is non-numeric, then LOG10 reports a #VALUE! error.
- If Number is less than or equal to 0, then LOG10 reports an invalid argument error (Err:502).
Additional details:
- For any positive real number x, [math]\displaystyle{ 10^{\text{log}(x)}=x }[/math] and [math]\displaystyle{ \text{log}(10^x)=x }[/math].
- To convert the common logarithm of a positive real number x to a natural logarithm (base-e), use the formula [math]\displaystyle{ \text{ln}(x)=\text{log}(x)~/~\text{log}(e) }[/math].
- Additional information about common logarithms can be found at Wikipedia's Common logarithm page.
- The figure below illustrates the LOG10 function.
Examples:
| Formula | Description | Returns |
|---|---|---|
| =LOG10(3.5) | Here the function returns the common logarithm of 3.5. | 0.544068044350276 |
| =LOG10(0.5) | Here the function returns the common logarithm of 0.5. | −0.301029995663981 |
| =LOG10(D1) where cell D1 contains the value 1. | Here the function returns the common logarithm of 1. | 0 |
| =LOG10(POWER(10; 1)) | Here the function returns the common logarithm of 10. | 1 |
| =LOG10(POWER(10; 34)) | Here the function returns the common logarithm of 10 raised to the power of 34, which is 34. | 34 |
| =POWER(10; LOG10(789)) | Here the function returns 10 to the power of the common logarithm of 789, which is 789. | 789 |
Related LibreOffice functions:
ODF standard:
Related (or similar) Excel functions:
LOG10