Documentation/Calc Functions/LOG10

    From The Document Foundation Wiki
    Other languages:


    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