Excel: QUOTIENT & MOD

➗ Divide & Remainder

Goal: Divide 10 items into groups of 3.
QUOTIENT counts full groups. MOD counts leftovers.

Ready...

          =QUOTIENT(numerator, denominator)
        

Returns the integer portion (Whole Groups).

          =MOD(number, divisor)
        

Returns the remainder (Leftovers).

-- Calculate Groups & Leftovers
=QUOTIENT( 10, 3 )
=MOD( 10, 3 )

Quotient (Groups): -

Mod (Leftovers): -

🚫 Divide Symbol (/)

Using =10/3 returns 3.333. Use QUOTIENT if you specifically want the integer (3) without rounding or decimals.

🚫 Zero Divisor

Dividing by zero causes a #DIV/0! error in both functions.