Microsoft Office Tutorials and References

In Depth Information

**Syntax**

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.

Syntax

=QUOTIENT(numerator,denominator)

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

numerator
—
This is the dividend.

•
denominator

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.