Syntax
QUOTIENT(numerator, denominator)
| Parameter | Description |
|---|---|
| numerator | Parameter of the QUOTIENT function. |
| denominator | Parameter of the QUOTIENT function. |
Examples
Full boxes from items
Formula
=QUOTIENT(250, 12)
Returns 20. You can fill 20 complete boxes of 12 from 250 items, with some left over (use MOD(250,12) to get the 10 remaining).
Hours from minutes
Formula
=QUOTIENT(475, 60)
Returns 7. There are 7 full hours in 475 minutes (with 55 minutes remaining).
Dollar bills needed
Formula
=QUOTIENT(A1, 20)
If A1 is 175, returns 8. You can make 8 complete $20 bills from $175.
Common Errors
#DIV/0!
Dividing by zero: =QUOTIENT(10, 0) returns #DIV/0! because division by zero is undefined.
#VALUE!
Passing non-numeric arguments like =QUOTIENT("ten", 3) produces this error.
Tips
Pair with MOD for remainder
QUOTIENT gives the whole part, MOD gives the leftover. Together: 250 items = QUOTIENT(250,12) boxes + MOD(250,12) loose items.
Truncates toward zero
QUOTIENT(-7, 2) returns -3, not -4. It truncates toward zero, unlike FLOOR which rounds toward negative infinity.
Different from INT(A/B)
INT(A1/B1) rounds down (toward negative infinity), while QUOTIENT truncates toward zero. They differ for negative numbers: INT(-7/2)=-4 but QUOTIENT(-7,2)=-3.
Try QUOTIENT in Viztab
Import your data and use QUOTIENT with 370+ other formulas. No signup required.
Open Viztab