Using the Excel QUOTIENT Function
SummaryThe Excel's QUOTIENT function returns only the integer portion after two numbers are divided. Use this function only if you want to discard the remainder of a division. Excel does not provide a DIVIDE function. To simply divide two figures, use the "/"; for example, 7 / 3 will return 2.33. Using QUOTIENT the result would be only 2.
Syntax=QUOTIENT (numerator, denominator)
Numerator is required and is the dividend.
Denominator is also required and is the divisor.
Usage NotesThe QUOTIENT function is useful when you would like to divide two numbers and only have the integer portion returned. QUOTIENT does not return the remainder. If you require the remainder, use the mathematical divisor operator (/).
For example, =QUOTIENT(13,3) will return 4, while =13/3 will return 4.33.
If either the numerator or denominator is non-numeric the function will return the #VALUE! error.
If the denominator is zero (0), the function returns the #DIV/0! error.