What is the Excel QUOTIENT Function?
The QUOTIENT function returns an integer portion of the division. This function is useful if you don’t need the remainder of a division.
QUOTIENT Syntax
QUOTIENT(numerator, denominator)
numerator, required, the number to be divided (the dividend)
denominator, required, the number that will divide the numerator (the divisor)
Usage Note:
- Returns #VALUE! error if non-numeric fills the numerator or denominator argument
- Returns #DIV/0! error if zero fills the denominator argument
- Use the MOD function to find the remainder of a division
- Use the division operator “/” for the division with a remainder
How to Use QUOTIENT Function in Excel
For example, there is data like the image below. What are the results of the QUOTIENT function in column B?
QUOTIENT Function #1
=QUOTIENT(A2,B2)
The result is #DIV/0! Error, because the denominator is zero.
QUOTIENT Function #2
=QUOTIENT(A3,B3)
The result is 2. The excel QUOTIENT function results are integer numbers, but you can enter decimal numbers in the numerator or denominator arguments.
QUOTIENT Function #3
=QUOTIENT(A4,B4)
The result is 1. Like the previous example, you can use the decimal number in both QUOTIENT function arguments. For QUOTIENT function #3 the decimal number fills the numerator argument.
QUOTIENT Function #4
=QUOTIENT(A5,B5)
The result is 2. Decimal numbers fill both the numerator and denominator arguments, but the result remains integer number.
QUOTIENT Function #5
=QUOTIENT(A6,B6)
The “number” 5,5 seems like a number but is a text; decimal number separators should use a period but use commas. Excel thinks it’s not a number, but a text.
The result is a #VALUE! Error.
QUOTIENT Function #6
=QUOTIENT(A7,B7)
The result is 3.
Please see the image below for the results of the six functions above.
