**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.