QUOTIENT Function
Purpose
Returns the integer portion of a division ($\lfloor \frac{\text{numerator}}{\text{denominator}} \rfloor$). Discards the fractional or decimal remainder.
Syntax
EXCEL
=QUOTIENT(numerator, denominator)
Arguments Breakdown
| Argument | Required? | Description |
|---|---|---|
numerator |
Required | The dividend (the number to be divided). |
denominator |
Required | The divisor (the number by which to divide). |
Practical Examples
1. Integer Packaging Drill
From Formulas_&_Functions_Part_1.xlsx:
If you have 29 items and each carton holds 6 items:
EXCEL
=QUOTIENT(29, 6)
Result: 4 full cartons (since $4 \times 6 = 24$, leaving 5 items leftover).
2. Time Conversion (Seconds to Full Hours)
EXCEL
=QUOTIENT(CallDurationInSeconds, 3600)
QUOTIENT vs Normal Division (/)
29 / 6returns4.833333333.QUOTIENT(29, 6)returns4.- Pair
QUOTIENTwithMODto get the complete division breakdown:- Full units:
=QUOTIENT(29, 6)$\rightarrow 4$ - Remaining units:
=MOD(29, 6)$\rightarrow 5$
- Full units:
Related Knowledge
- Notes: 02 Statistical and Aggregation Functions
- Workbook:
11_Demos_and_Workbooks/03_Formulas_and_Functions/Formulas_&_Functions_Part_1.xlsx(Sheet:Arithmetic and statistical)