QUOTIENT function in Excel returns the integer portion of Division .i.e. Quotient portion of division.
Syntax of QUOTIENT Function in Excel
QUOTIENT( numerator, denominator )
numerator – The Number to be divided
denominator – The Number that divides.
Example of QUOTIENT Function in Excel
Formula
- In row number 2 and 3, both Numerator and Denominator have positive values
- In row number 4 Numerator is negative and Denominator have positive value
- In row number 5 Numerator is positive and Denominator have negative value
- Row number 6 Numerator and Denominator are passed as values rather than cell reference
So the result will be
Result
Note: #VALUE! Error occurs if the supplied number argument is non-numeric.
#DIV/0! Error occurs if the denominator argument is Zero