Excel like a finance pro.
← The libraryPractice · 3 questions →
Math function
QUOTIENT
Returns the integer part of a division, discarding the remainder.
OccasionalDifficulty 1050 · CapableUsage rank #177 of 520
When to use it
Returns only the integer part of a division and throws away the remainder. Pair it with MOD to split a quantity into whole units and leftovers.
The shape of it
- Syntax
=QUOTIENT(numerator, denominator)
Worked examples
Whole part of a division
=QUOTIENT(10,3) → 3
The remainder 1 is discarded.
Negative numerator
=QUOTIENT(-10,3) → -3
Truncates toward zero; INT(-10/3) would be -4.
Months into years
=QUOTIENT(127,12) → 10
127 months is 10 full years, with MOD(127,12) = 7 months over.
Worth knowing
- QUOTIENT(a,b) is the same as TRUNC(a/b) and reads more clearly.
- Cases per pallet, pallets per truck: chain QUOTIENT calls.
- Use INT(a/b) instead when you specifically want floor behavior for negatives.
Where it goes wrong
- #DIV/0! when the denominator is 0.
- Truncates toward zero, so it is not the same as INT for negative results.
Related
Learn the moves here — or let Wauvel run them on your numbers.
Meet your AI CFO →One CFO-grade Excel tip a week
A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.