QUOTIENT function
Quick answer
QUOTIENT divides one number by another and returns only the whole-number part, dropping the remainder.
- Syntax
=QUOTIENT(numerator, denominator)- Most common use
=QUOTIENT(B2,C2)returns 10 (250 pens fill 10 boxes of 24)
Use it for how many full boxes, full hours or full weeks fit, and pair it with MOD for what's left over. It truncates toward zero, so for negative results it differs from INT, which rounds down.
- Available in
- Every current version
- Category
- Math functions
- Returns
- A whole number; #DIV/0! if the denominator is 0.
- Google Sheets
- Works the same in Google Sheets.
Syntax
=QUOTIENT(numerator, denominator)
| Argument | Required? | What it is |
|---|---|---|
numerator | Required | The number to divide. |
denominator | Required | The number to divide by. |
Examples
Each result below is calculated from the sample sheet by our formula engine, the same one that grades the practice.
| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | =QUOTIENT(B2,C2) | 10 | 250 pens fill 10 boxes of 24 |
| D3 | =QUOTIENT(B3,C3) | 7 | 90 mugs fill 7 boxes of 12 |
| E2 | =MOD(B2,C2) | 10 | MOD gives the 10 pens left over |
Try it live
This is the sample sheet. Change any number or text, or edit a formula, and the results update.
Show the sample data as a table
| Item | Units | Per box | Full boxes | Left over |
| Pens | 250 | 24 | 10 | 10 |
| Mugs | 90 | 12 | 7 | |
| Pads | 44 | 10 |
Practice QUOTIENT
Graded instantly, then re-checked on changed data.
Full crates
D2, calculate how many full crates each order fills, from the bottles ordered in B2 and the bottles per crate in C2. Fill down to D6.Common mistakes
| What you see | Why, and how to fix it |
|---|---|
| #DIV/0! | The denominator is 0 or blank. Guard it: =IF(C2=0,"",QUOTIENT(B2,C2)). |
| A negative result is one higher than expected | QUOTIENT(-7,2) is -3 because it truncates toward zero, while INT(-7/2) is -4. Pick the one that matches what you mean. |
Tips
- =QUOTIENT(A2,60)&"h "&MOD(A2,60)&"m" turns 135 minutes into 2h 15m.
Questions
How do I divide without a remainder in Excel?
=QUOTIENT(A2,B2) gives the whole number of times B2 fits into A2. =MOD(A2,B2) gives the remainder.
Is QUOTIENT the same as INT(A2/B2)?
For positive numbers, yes. For negative results QUOTIENT truncates toward zero while INT rounds down, so they differ by 1.
Updated Checked by running: every formula on this page was run by our formula engine on .