Jump to content

Documentation/Calc Functions/LOG10

From The Document Foundation Wiki


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.
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:

EXP

LN

LOG

POWER

ODF standard:

Section 6.16.41, part 2

Related (or similar) Excel functions:

LOG10