Documentation/Calc Functions/QUOTIENT
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
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:
ODF standard:
Related (or similar) Excel functions:
QUOTIENT