What is the difference between QUOTIENT and ordinary division?

QUOTIENT returns only the integer part, discarding any decimal remainder, while division (=A/B) returns the full decimal quotient. For example, QUOTIENT(7, 2) equals 3, but 7/2 equals 3.5.

Does QUOTIENT round or truncate?

QUOTIENT truncates toward zero—it drops the remainder without rounding. QUOTIENT(9, 2) returns 4 and QUOTIENT(−9, 2) returns −4. Use ROUND(A/B, 0) if you need rounding instead.

Can QUOTIENT handle negative numbers?

Yes, QUOTIENT works with negative numerators and denominators, truncating toward zero. QUOTIENT(−10, 3) returns −3 and QUOTIENT(10, −3) returns −3, following standard division sign rules.

How do I capture the remainder after using QUOTIENT?

Use MOD(numerator, denominator) for the remainder. Together they fully partition a number: QUOTIENT(10, 3) equals 3 and MOD(10, 3) equals 1, so 10 = 3×3 + 1.

QUOTIENT function

Returns the integer quotient of a division operation, discarding the remainder—useful for finding complete groups or batches from a total.

=QUOTIENT(numerator, denominator)

Generate a QUOTIENT formula

Describe what you need. The generator will reach for QUOTIENT where QUOTIENT is the right tool, and tell you when it is not.

Arguments

How QUOTIENT reads its arguments

Argument	Required	Description
numerator	Required	A number or cell reference to divide; if zero or negative, it is treated as-is in the calculation.
denominator	Required	A number or cell reference to divide by; must not be zero, or a #DIV/0! error results.

Returns

An integer representing the whole number quotient without a remainder.

Availability

Excel: All · Google Sheets: Supported

Worked examples

1. Calculate complete 8-hour workdays from logged hours

Task	Owner	Start	Due	Hours
Design mockups	Alice	1/1	1/5	40

=QUOTIENT(40, 8)

Result: 5

40 logged hours divided by 8-hour workdays yields 5 complete days. QUOTIENT discards the remainder entirely, keeping only the integer quotient—in this case there is no remainder, but any fractional part would be dropped.

2. Determine how many complete features fit within available hours

Task	Owner	Start	Due	Hours
Backend API	Bob	1/2	1/8	56

=QUOTIENT(56, 15)

Result: 3

56 hours divided by 15 hours per feature equals 3 complete features. The remaining 11 hours (56 − 45) are truncated away by QUOTIENT, leaving only the count of fully finished features.

3. Calculate how many complete 40-hour work weeks are represented

Task	Owner	Start	Due	Hours
Backend API	Bob	1/2	1/8	56

=QUOTIENT(56, 40)

Result: 1

56 hours divided by 40 hours per standard work week produces 1 complete week. The 16 remaining hours are dropped—QUOTIENT never rounds up, only truncates toward zero.

Common errors

Which QUOTIENT error are you seeing?

Error	Why it happens	How to fix it
#DIV/0!	The denominator is zero, making division mathematically undefined.	Verify the denominator value is not zero. Add a guard like =IF(B2=0, "N/A", QUOTIENT(A2, B2)) to handle edge cases gracefully.
#VALUE!	One or both arguments are text strings or other non-numeric types instead of numbers.	Ensure both arguments are numeric. If Hours is stored as text, convert it: =QUOTIENT(VALUE(A2), 8).
#REF!	A cell reference in the formula points to a deleted cell, moved range, or otherwise invalid location.	Repair the cell references to point to valid cells in the current sheet. For example, change a broken reference to =QUOTIENT(D2, 8).

Tips and when to use something else

QUOTIENT always truncates toward zero—it never rounds. Use ROUND(A1/B1, 0) if you need standard rounding behavior instead.
For remainders, pair QUOTIENT with MOD: =QUOTIENT(hours, 8) gives complete days and =MOD(hours, 8) gives leftover hours.
When you need decimal precision or percentages, use division (=A1/B1) instead; QUOTIENT loses fractional information permanently.
ROUNDDOWN(numerator/denominator, 0) and INT(numerator/denominator) produce identical results to QUOTIENT but offer more explicit control.

Related functions

MODMOD returns the remainder after dividing one number by another, making it useful for identifying patterns, cycles, and divisibility in data.ROUNDROUND returns a number rounded to a specified number of decimal places, using standard rounding rules (0.5 rounds up).INTINT rounds any number down to the nearest whole integer, always discarding decimal places and rounding toward negative infinity.ROUNDDOWNROUNDDOWN returns a number rounded down toward zero to the specified number of decimal places, useful for inventory and billing calculations.FLOOR.MATHRounds a number down to the nearest multiple of a specified significance value, commonly used for budget categories and interval-based rounding.

Frequently asked questions

What is the difference between QUOTIENT and ordinary division?: QUOTIENT returns only the integer part, discarding any decimal remainder, while division (=A/B) returns the full decimal quotient. For example, QUOTIENT(7, 2) equals 3, but 7/2 equals 3.5.
Does QUOTIENT round or truncate?: QUOTIENT truncates toward zero—it drops the remainder without rounding. QUOTIENT(9, 2) returns 4 and QUOTIENT(−9, 2) returns −4. Use ROUND(A/B, 0) if you need rounding instead.
Can QUOTIENT handle negative numbers?: Yes, QUOTIENT works with negative numerators and denominators, truncating toward zero. QUOTIENT(−10, 3) returns −3 and QUOTIENT(10, −3) returns −3, following standard division sign rules.
How do I capture the remainder after using QUOTIENT?: Use MOD(numerator, denominator) for the remainder. Together they fully partition a number: QUOTIENT(10, 3) equals 3 and MOD(10, 3) equals 1, so 10 = 3×3 + 1.

Need a different formula?

The full generator is not scoped to one function — describe any spreadsheet problem and it will pick.

Open the formula generator

Reviewed 2026-09-17