Documentation/Calc Functions/QUOTIENT

    From The Document Foundation Wiki
    Other languages:


    Function name:

    QUOTIENT

    Category:

    Mathematical

    Summary:

    Calculates the integer part of the result of dividing one number (the dividend or numerator) by another number (the divisor or denominator).

    Often the dividend and divisor will be integer values (Euclidean division). However, QUOTIENT accepts and processes real numbers with non-zero fractional parts.

    Syntax:

    QUOTIENT(Numerator; Denominator)

    Returns:

    Returns an integer that is the integer part of the result of the division operation.

    Arguments:

    Numerator is a real number, or a reference to a cell containing that number, that is the numerator or dividend of the division operation.

    Denominator is a non-zero real number, or a reference to a cell containing that number, that is the denominator or divisor of the division operation.

    • If either Numerator or Denominator is non-numeric, then QUOTIENT reports a #VALUE! error.
    • If Denominator is equal to 0, then QUOTIENT reports an invalid argument error (Err:502).
    • If Numerator is equal to 0, then QUOTIENT returns 0.
    • If the signs of Numerator and Denominator are different, then the result is negative and rounded towards 0 by taking its ceiling value.
    • If the signs of Numerator and Denominator are the same, then the result is positive and rounded towards 0 by taking its floor value.

    Additional details:

    • When dividend and divisor have the same sign, the formula describing the divide operation can be written as

    [math]\displaystyle{ \frac{\text{dividend}}{\text{divisor}} ~=~ \text{quotient} + \frac{\text{remainder}}{\text{divisor}} }[/math]

    If you are interested in the remainder in this formula, then use the MOD function.

    Examples:

    Formula Description Returns
    =QUOTIENT(11; 3) The function divides 11 by 3 and takes the integer part of the result. The remainder is lost. The formula =QUOTIENT(-11; -3) gives the same result. 3
    =QUOTIENT(-11; 3) The function divides -11 by 3 and takes the integer part of the result. The remainder is lost. The formula =QUOTIENT(11; -3) gives the same result. -3
    =QUOTIENT(D1; D2)

    where cells D1 and D2 contain the numbers 11.25 and 2.5 respectively.

    The function divides 11.25 by 2.5 and takes the integer part of the result. The remainder is lost. 4

    Related LibreOffice functions:

    CEILING

    FLOOR

    INT

    MOD

    ROUND

    TRUNC

    ODF standard:

    Section 6.16.48, part 2

    Related (or similar) Excel functions:

    QUOTIENT