Documentation/Calc Functions/QUOTIENT

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:

 * The formula describing the divide operation can be written as

$$\frac{\text{ dividend }}{\text{ divisor }} ~=~ \text{ quotient } + \frac{\text{ remainder }}{\text{ divisor }}$$


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

Related LibreOffice functions:
MOD

ODF standard:
Section 6.16.48, part 2

Equivalent Excel functions:
QUOTIENT