Math function

Excel QUOTIENT function

Q: How do I divide in Excel without the remainder?

Use =QUOTIENT(A2,B2) or =INT(A2/B2). They give the same answer for positive numbers; for negatives QUOTIENT cuts toward zero and INT rounds down.

Q: How do I get the remainder in Excel?

Use MOD: =MOD(250,24) returns 10. QUOTIENT gives the whole part and MOD the remainder, so QUOTIENT(a,b)*b+MOD(a,b) adds back to a for positive numbers.

QUOTIENT divides one number by another and returns only the whole-number part, throwing the remainder away. It answers "how many full boxes, full hours or full weeks fit?" Pair it with MOD, which returns the part QUOTIENT throws away.

=QUOTIENT(numerator, denominator)

Arguments

numerator: The number to divide, such as the units in an order.
denominator: The number to divide by, such as the units per case. 0 or an empty cell returns #DIV/0!.

QUOTIENT examples

Every result below was calculated from this sample sheet by the same spreadsheet engine the Cellwise app uses.

	A	B	C
1	Order	Units	Per case
2	SO-2201	250	24
3	SO-2202	96	12
4	SO-2203	41	6
5	SO-2204	1300	48

Download this sheet as an Excel practice file (.xlsx)

=QUOTIENT(B2,C2)
Result: 10
250 units fill 10 full cases of 24. The 10 units left over are dropped, not rounded.
=QUOTIENT(B2,C2)&" cases + "&MOD(B2,C2)&" loose"
Result: 10 cases + 10 loose
QUOTIENT and MOD together give the packing slip line: 10 cases + 10 loose.
=QUOTIENT(B4,C4)+(MOD(B4,C4)>0)
Result: 7
Cases you need to ship 41 units: 6 full cases plus one more for the 5 left over, so 7. The TRUE from MOD(...)>0 counts as 1. =ROUNDUP(B4/C4,0) gives the same.
=QUOTIENT(-7.9,2)&" vs "&INT(-7.9/2)
Result: -3 vs -4
With negatives they differ: QUOTIENT cuts toward zero (-3), INT rounds down to the next lower whole number (-4).

How to use QUOTIENT

Click the cell for the result.
Type =QUOTIENT( then the number to divide, a comma, and the number to divide by.
Close the bracket and press Enter.
Add MOD with the same two arguments in the next column when you also need what is left over.

Common QUOTIENT mistakes

Using it to work out how many boxes to order

QUOTIENT rounds down, so 41 units at 6 per case says 6 and leaves 5 units unshipped. Use =ROUNDUP(B4/C4,0) when a partial box still needs a box.

Expecting INT and QUOTIENT to match on negatives

QUOTIENT(-7.9,2) is -3 and INT(-7.9/2) is -4. For refunds, credits or other negative amounts, pick the one whose rule you want and test it on a negative row.

A blank or zero divisor

An empty "Per case" cell counts as 0 and returns #DIV/0!. Wrap it: =IF(C2=0,"",QUOTIENT(B2,C2)).

QUOTIENT FAQ

How do I divide in Excel without the remainder?

Use =QUOTIENT(A2,B2) or =INT(A2/B2). They give the same answer for positive numbers; for negatives QUOTIENT cuts toward zero and INT rounds down.

How do I get the remainder in Excel?

Use MOD: =MOD(250,24) returns 10. QUOTIENT gives the whole part and MOD the remainder, so QUOTIENT(a,b)*b+MOD(a,b) adds back to a for positive numbers.

What is the difference between QUOTIENT and TRUNC?

QUOTIENT(a,b) is the same as TRUNC(a/b): both drop the decimals toward zero. TRUNC can also keep some decimals, such as TRUNC(a/b,1).

Does QUOTIENT work in every version of Excel?

Yes. QUOTIENT works in all current versions of Excel, Excel for the web and Google Sheets.

Related functions

Updated November 5, 2026