Excel QUOTIENT Function
Figure 1. Using excel quotient function
=QUOTIENT (Numerator, Denominator)
The QUOTIENT function in Microsoft Excel is often used to perform a division operation on two numeric values, and it’ll return the whole number only as a result, not the remainder.
There is no “division” function in Microsoft Excel which will give you with both the integer portion and the remainder.
- To perform “division operations” wherever the integer portion and decimal are returned, use a “division formula”.
- To return only the remainder – use the “MOD function”.
How the formula Works
The Syntax of QUOTIENT Function
A syntax refers to the procedure of the function and the function’s name, comma separators, brackets, and arguments.
The QUOTIENT function syntax is:
=QUOTIENT (dividend, divisor)
Dividend (required) – the Numerator (the numeric value written preceding the forward slash (/) in a division operation).
Divisor (required) – the Denominator (the numeric value written succeeding forward slash in a division operation).
Errors Using the QUOTIENT Function
#DIV/0! – This occurs if the divisor value is equal to zero or references a blank cell.
#VALUE! – This occurs if any argument is not a numeric value. example
Figure 2. Quotient function error