Syntax. QUOTIENT(numerator,denominator)
Definition. This function returns the integer portion of a division operation. If this function is not available and you get the #NAME? error, you need to install and activate the add-in analysis functions.
Arguments
numerator (required) The dividend
denominator (required) The divisor
Background. The division operation is the inverse of the multiplication operation and can be indicated by a colon, as in a : b or a fraction line, as in
The colon and the fraction line are interchangeable signs. However, Excel formulas use the slash (/) as the operator for division.
See Also
You will find more information about the use of operators in Excel formulas in Chapter 3.
If one of the arguments isn’t a numeric expression, the QUOTIENT() function returns the #VALUE! error. If the divisor is 0, the QUOTIENT() function returns the #DIV/0! error.
Example. A painter has a roll of wallpaper of 395.67 inch length. He need wallpaper strips with 96.46 inch length. How many wallpaper strips he receives from one roll? The formula is:
=QUOTIENT(395.67,96.46)
The result is 4. He receives 4 wallpaper strips from one roll.