Excel QUOTIENT Function: Whole-Number Division
Divides two numbers and returns only the whole-number part.
QUOTIENT divides and throws away the remainder. 47 divided by 12 is 3.9166, so =QUOTIENT(47, 12) is 3. It is the other half of MOD: one gives you how many whole times something fits, the other gives you what is left over.
Together they answer packing questions completely. 47 items into boxes of 12 is 3 full boxes with 11 left over — QUOTIENT gives the 3 and MOD gives the 11. Either alone tells you half the story.
It is worth knowing that INT and TRUNC do almost the same thing on the result of a division, and differ on negatives: QUOTIENT and TRUNC cut toward zero, so -47/12 gives -3, while INT rounds down the number line and gives -4.
Syntax
=QUOTIENT(numerator, denominator)Arguments
numeratorRequired- The number being divided.
denominatorRequired- What to divide by. It cannot be zero.
The example data
Headers in row 1, data in A2:D5.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Item | On hand | Per box | Adjustment |
| 2 | Cordless drill | 47 | 12 | -8 |
| 3 | Extension lead | 140 | 24 | 15 |
| 4 | Safety goggles | 63 | 18 | 0 |
| 5 | Work gloves | 210 | 30 | -22 |
Worked examples
=QUOTIENT(B2, C2)Result: 3
47 items make 3 full boxes of 12. The leftovers are discarded.
=MOD(B2, C2)Result: 11
The other half of the answer: 11 items left over after those 3 boxes.
=QUOTIENT(B4, C4)Result: 3
63 into boxes of 18 gives 3 full boxes, with 9 remaining.
=QUOTIENT(B2, C2) & " boxes + " & MOD(B2, C2) & " loose"Result: 3 boxes + 11 loose
The pair used together, which is how packing lists are actually written.
Now practise it
Reading about a formula is not the same as writing one. Open this function's exercise and type it into a real grid — you get instant feedback on exactly which cell is wrong and why.
Common errors and how to fix them
#DIV/0!
Why it happens: The denominator is zero or a blank cell being read as zero.
How to fix it: Guard it with IFERROR, or test the denominator before dividing.
#VALUE!
Why it happens: One of the arguments is text.
How to fix it: Both must be numeric. QUOTIENT does not coerce text the way some operators do.
Wrong answer on negatives
Why it happens: QUOTIENT truncates toward zero, so -47 divided by 12 is -3 rather than -4.
How to fix it: Use INT if you want rounding down the number line instead. The two agree on positive numbers and differ on negative ones.
Tips worth knowing
- QUOTIENT and MOD are a pair: whole part and remainder from the same division.
- =INT(A2/B2) does the same thing on positive numbers and is more widely recognised.
- For a count of containers you need CEILING, not QUOTIENT — 47 items still needs a fourth box for the leftovers.
- Convert minutes to hours and minutes with QUOTIENT(m, 60) and MOD(m, 60).
Frequently asked questions
What is the difference between QUOTIENT and normal division?
Normal division returns the exact answer including decimals; QUOTIENT returns only the whole-number part. 47/12 is 3.9166 while QUOTIENT(47, 12) is 3.
What is the difference between QUOTIENT and INT?
On positive numbers, nothing. On negatives they diverge: QUOTIENT truncates toward zero and INT rounds down the number line, so QUOTIENT(-47, 12) is -3 and INT(-47/12) is -4.
How do I get both the whole boxes and the leftovers?
Use QUOTIENT for the boxes and MOD for the leftovers, both with the same two arguments. They are two halves of one division and are almost always used together.
Related functions
Guides that use it
Longer reads where this function does real work in a real sheet.