Returns the integer part of a division operation.
Returns the integer part of Numerator divided by Denominator.
Numerator is a real number or a reference to the cell containing that number which is the number by which Denominator is divided.
Denominator is a real non-zero number or a reference to the cell containing that number which is dividing the Numerator.
- If Denominator is 0, QUOTIENT function returns an error value.
- If arguments are non-integral then the floor of the absolute value of the result is taken and returned with appropriate sign, i.e. the result is truncated to integer.
- If sign of exactly one argument is negative, the result will have negative sign else the result will have positive sign.
QUOTIENT is equivalent to INT(numerator/denominator) for same-sign numerator and denominator, except that it may report errors with different error codes. More generally, it is equivalent to INT(numerator/denominator/SIGN(numerator/denominator))*SIGN(numerator/denominator).
|=QUOTIENT(11;3)||integer part when 11 divides 3 and remainder of 2 is lost||3|
|=QUOTIENT(11.7;3)||integer part when 11.7 divides 3 and remainder of 0.3 is lost, taking floor of the absolute value||3|
|=QUOTIENT(-5.9;1.8)||integer part when -5.9 divides 1.8 and remainder of 1.3 is lost, taking floor of the absolute value and returning with negative sign||-3|
|=QUOTIENT(-11.7;3)||integer part when -11.7 divides 3 and remainder of 0.3 is lost, taking floor of the absolute value and returning with negative sign||-3|
|=QUOTIENT(11;0)||Denominator is 0 so the function returns an error value||Err:502|
Related LibreOffice functions:
Equivalent Excel functions: