Documentation/Calc Functions/QUOTIENT

From The Document Foundation Wiki
Jump to: navigation, search
This page contains changes which are not marked for translation.

Other languages:
dansk • ‎English

Function name:

QUOTIENT

Category:

Mathematical

Summary:

Returns the integer part of a division operation.

Syntax:

QUOTIENT(Numerator; Denominator)

Returns:

Returns the integer part of Numerator divided by Denominator.

Arguments:

Numerator is a real number or a reference to the cell containing that number which is the number the Denominator divides.

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, the QUOTIENT function returns an error value.
  • If arguments are non-integral then the floor of the result is taken and returned with an appropriate sign, i.e. the result is truncated to an integer.
  • If the sign of exactly one argument is negative, the result will have a negative sign else the result will have a positive sign.

Additional details:

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).

Examples:

Formula Description Returns
=QUOTIENT(11;3) integer part when 11 is divided by 3 and remainder of 2 is lost 3
=QUOTIENT(11.7;3) integer part when 11.7 is divided by 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 is divided by 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 is divided by 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:

MOD

ODF standard:

Section 6.16.48, part2

Equivalent Excel functions:

QUOTIENT