QUOTIENT

Using the Excel QUOTIENT Function

Summary

The 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)

Syntax Breakdown

numerator
Numerator is required and is the dividend.

denominator
Denominator is also required and is the divisor.


Usage Notes

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

QUOTIENT Errors
If either the numerator or denominator is non-numeric the function will return the #VALUE! error.

Excel QUOTIENT VALUE Error

If the denominator is zero (0), the function returns the #DIV/0! error.

Excel QUOTIENT DIV Error