The Excel QUOTIENT function returns the integer (whole-number) part of a division, discarding the remainder. It truncates toward zero rather than rounding.
Syntax
| Argument | Description | |
|---|---|---|
numerator | Required | The number being divided (the dividend). |
denominator | Required | The number to divide by. If 0, QUOTIENT returns a #DIV/0! error. |
How to use it
QUOTIENT keeps only the whole-number part of a division and drops anything after the decimal point.
It pairs naturally with MOD: QUOTIENT gives the times-it-goes-in and MOD gives the leftover. Use it to convert units (how many whole dozens in 40 eggs: =QUOTIENT(40,12) = 3).
QUOTIENT truncates toward zero — it does not round. =QUOTIENT(-10,3) = -3, the same way TRUNC drops decimals. Compare with INT, which rounds down (toward negative infinity), so INT(-10/3) = -4.
Try it: interactive demo
Pick a QUOTIENT example to see the formula and its result.
Practice workbook
Frequently asked questions
Does QUOTIENT round or truncate?
=QUOTIENT(10,3) = 3 and =QUOTIENT(-10,3) = -3 — no rounding occurs.How is QUOTIENT different from INT?
=QUOTIENT(-10,3) = -3 but =INT(-10/3) = -4.What does QUOTIENT do with the remainder?
What if the denominator is zero?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class