# 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