Quick Navigation
QUOTIENT Function
Summary
The Excel QUOTIENT function returns the integer portion of a division, effectively discarding the remainder. It's perfect for scenarios where you need whole numbers from division operations without fractional parts.
Syntax
QUOTIENT(numerator, denominator)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| numerator | Number |
Yes | The dividend - the number you want to divide |
| denominator | Number |
Yes | The divisor - the number you want to divide by |
Using the QUOTIENT Function
QUOTIENT is ideal when you need the whole number result of division. Unlike regular division with '/', which returns decimals, QUOTIENT gives you only the integer part, making it perfect for calculations requiring whole units.
Common QUOTIENT Examples
Basic Integer Division
=QUOTIENT(5,2)Divides 5 by 2 and returns 2 (discards 0.5 remainder)
Decimal Division
=QUOTIENT(4.5,3.1)Divides 4.5 by 3.1 and returns 1 (discards fractional remainder)
Negative Number Handling
=QUOTIENT(-10,3)Divides -10 by 3 and returns -3 (proper negative quotient)
Frequently Asked Questions
Common Errors and Solutions
#VALUE! Error
Cause: Either numerator or denominator contains non-numeric values
Solution: Ensure both arguments are valid numbers
#DIV/0! Error
Cause: Denominator is zero or empty
Solution: Provide a non-zero denominator
Notes
- QUOTIENT always returns an integer, even with decimal inputs
- Use regular '/' operator when you need the full decimal result
- To get the remainder, use MOD function: MOD(numerator, denominator)
- Available in Excel 2007 and later versions
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+