What is the syntax for QUOTIENT in Excel?

The syntax for QUOTIENT is: =QUOTIENT(numerator, denominator)

What is QUOTIENT in Excel?

QUOTIENT returns only the integer part of division, discarding the remainder. QUOTIENT(10,3)=3 because 10÷3=3.33... and QUOTIENT keeps only the 3. It's equivalent to INT(A/B) for positive numbers.

How do I get both quotient and remainder?

Use QUOTIENT for the whole number part and MOD for the remainder. For 17÷5: QUOTIENT(17,5)=3 (whole part), MOD(17,5)=2 (remainder). Together: 17 = 3×5 + 2.

How do I convert minutes to hours and minutes?

For 150 minutes: Hours = QUOTIENT(150,60) = 2, Minutes = MOD(150,60) = 30. Result: 2 hours 30 minutes. Formula: =QUOTIENT(A1,60)&" hrs "&MOD(A1,60)&" min".

Math & Trig

QUOTIENT Function in Excel

Returns the integer portion of a division.

Syntax

=QUOTIENT(numerator, denominator)

Arguments

numerator (required): Dividend
denominator (required): Divisor

Examples

=QUOTIENT(10, 3) - Integer division - Result: 3

QUOTIENT in reporting workflows

Use absolute references when copying formulas across rows.
For conditional totals see [SUMIF](/functions/sumif/) and [SUMIFS](/functions/sumifs/).
Filtered lists may need [SUBTOTAL](/functions/subtotal/) instead of SUM on visible cells only.

Common errors

#DIV/0! if denominator is 0

Use cases

Integer division
Grouping
Calculations

Frequently asked questions

What is QUOTIENT in Excel? QUOTIENT returns only the integer part of division, discarding the remainder. QUOTIENT(10,3)=3 because 10÷3=3.33... and QUOTIENT keeps only the 3. It's equivalent to INT(A/B) for positive numbers.
How do I get both quotient and remainder? Use QUOTIENT for the whole number part and MOD for the remainder. For 17÷5: QUOTIENT(17,5)=3 (whole part), MOD(17,5)=2 (remainder). Together: 17 = 3×5 + 2.
How do I convert minutes to hours and minutes? For 150 minutes: Hours = QUOTIENT(150,60) = 2, Minutes = MOD(150,60) = 30. Result: 2 hours 30 minutes. Formula: =QUOTIENT(A1,60)&" hrs "&MOD(A1,60)&" min".

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.