# Documentation/Calc Functions/QUOTIENT

Jump to navigation
Jump to search

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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:

## ODF standard:

## Equivalent Excel functions:

QUOTIENT