QUOTIENT
Returns the integer portion of a division. Discards the remainder and returns only the whole number result.
QUOTIENT(numerator, denominator)Arguments
numeratorThe dividend (number to be divided)denominatorThe divisor (number to divide by)
=QUOTIENT(7, 2)7 divided by 2 is 3 with remainder 1, returns 3
=QUOTIENT(100, 7)100 / 7 = 14.28..., integer part is 14
=QUOTIENT(-10, 3)Truncates toward zero
- •Similar to INT(A/B) but handles negatives differently
- •Use MOD() to get the remainder instead
- •Returns #DIV/0! if denominator is 0
- •Expecting QUOTIENT to return a decimal result - it always returns only the integer portion of a division, discarding any remainder or decimal entirely
- •Using QUOTIENT with a denominator of zero, which returns a #DIV/0! error just like a normal division by zero
- •Forgetting that QUOTIENT truncates toward zero rather than rounding, so QUOTIENT(-7,2) returns -3, not -4, which can surprise anyone expecting standard rounding behavior for negative results
MODReturns the remainder of a division, the complementary value to what QUOTIENT discards.INTRounds down to the nearest integer, which behaves differently from QUOTIENT's truncation for negative results.TRUNCPerforms the same truncation-toward-zero behavior as QUOTIENT, but takes a single number and decimal-places argument rather than two numbers to divide.Does QUOTIENT round the result of a division?
No, it truncates - it keeps only the integer portion of the division result and discards everything after the decimal point, without any rounding.
Why does QUOTIENT(-7,2) return -3 instead of -4?
QUOTIENT truncates toward zero, not away from it, so -3.5 becomes -3, not -4. This differs from INT, which would round down to -4.
How is QUOTIENT different from MOD?
They're complementary - QUOTIENT gives the integer part of a division, while MOD gives what's left over (the remainder). Together, QUOTIENT(a,b)*b + MOD(a,b) reconstructs the original value a.
Need to translate a formula using QUOTIENT?
Use our translator to convert your complete formula