QUOTIENT

Returns the integer part of a division operation.

Syntax:

QUOTIENT(numerator; denominator)

returns the integer part of numerator divided by denominator. QUOTIENT is equivalent to INT(numerator/denominator), except that it may report errors with different error codes.

Example:

QUOTIENT(11; 3)

returns 3, the integer part of 11 divided by 3. The remainder of 2 is lost.

Application:

Calculating Batches for an Order

Imagine you are managing the shipping department for a company that sells t-shirts. The t-shirts are packaged in boxes of 12. You need to quickly figure out how many full boxes are needed for a given order and how many individual t-shirts are left over.

This is a perfect scenario for the QUOTIENT function. The QUOTIENT function calculates the integer part of a division, which in this case represents the number of full boxes.

The formula would be: QUOTIENT(total_t-shirts, t-shirts_per_box)

Here is a table demonstrating this for a few different orders:

	Order ID	Total T-Shirts	T-Shirts per Box	Full Boxes Needed (using QUOTIENT)	Remainder (Individual T-Shirts)
	A	B	C	D	E
1	A-101	150	12	12	6
2	B-205	72	12	6	0
3	C-334	215	12	17	11
4	D-450	36	12	3	0
5	E-512	10	12	0	10

Explanation of the calculation:

Order A-101: You have 150 t-shirts. Each box holds 12. The QUOTIENT(150, 12) is 12. This tells you that you need 12 full boxes. The remainder (150 - (12 * 12)) is 6, which are the individual t-shirts left over.
Order B-205: You have exactly 72 t-shirts. QUOTIENT(72, 12) is 6. You need exactly 6 full boxes with no t-shirts left over.
Order C-334: You have 215 t-shirts. QUOTIENT(215, 12) is 17. You need 17 full boxes. The remainder is 11.
Order E-512: You only have 10 t-shirts. QUOTIENT(10, 12) is 0. This correctly tells you that you cannot fill any full boxes, so all 10 t-shirts are considered individual items.