QUOTIENT Function in Excel: Whole-Number Division

⏱ 1 min readUpdated 28 September 2026

MathLevel: IntermediateAvailable in: Excel 2007+

In this article
  1. Syntax
  2. Examples
  3. Example 1
  4. Example 2
  5. Related functions

QUOTIENT returns only the integer part of a division; MOD returns the remainder.

Syntax

=QUOTIENT(numerator, denominator)
Argument What it means
numerator, denominator Numbers.

Examples

Example 1

=QUOTIENT(B2, 12)&" boxes + "&MOD(B2, 12)&" loose"

150 items → 12 boxes + 6 loose.

Example 2

=QUOTIENT(A2, 60)&"h "&MOD(A2, 60)&"m"

Minutes into hours and minutes.

MOD · INT

📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.

Keep reading

Excel Functions A–ZMAX Function in Excel: Largest Value in a RangeExcel Functions A–ZT.DIST Function in Excel: Student’s t ProbabilityExcel Functions A–ZMDETERM Function in Excel: Determinant of a Matrix
✨ Ask AI about this article

Stuck on a step? Ask a question and the AI answers using this article.

Free · AI can be wrong