Microsoft Office Tutorials and References
In Depth Information
If you divide 43 by 4, the answer is 10 with a remainder of 3. The QUOTIENT
function returns just the whole number 10 and ignores the remainder.
This function is great for calculating full cases of products. Suppose you
pay a worker for assembling products. You pay the worker for each com-
plete case of four items produced. If he produces 43 items in his shift, this is
10 complete cases. =QUOTIENT(43,4) would provide an answer of 10.
The QUOTIENT function returns the integer portion in a division problem. You
use this function when you want to discard the remainder in a division prob-
lem. This function takes the following arguments:
numerator — This is the dividend.
denominator — This is the divisor.
If either argument is nonnumeric, QUOTIENT returns a #VALUE! error.
Many people simulate the QUOTIENT function by using the INT function. To
keep the integer portion of a division, you could use =INT(43/4). However,
QUOTIENT and INT differ when the result is negative. Whereas
QUOTIENT(5, – 4) returns – 1, INT(5/ – 4) actually goes down to – 2. Thus, us-
ing QUOTIENT is more accurate than using INT if the results might be negat-
ive. If you are a fan of using INT to simulate the QUOTIENT, consider us-
ing TRUNC() or CEILING.MATH() instead. Figure 11.30 shows the differences
between QUOTIENT, INT, TRUNC, and CEILING.MATH.