Article updated on April 20, 2018

The quotient function returns the integer portion of a division.

Excel Function Syntax

QUOTIENT(numerator, denominator)

Arguments

numerator Required. The dividend.
denominator Required. The divisor.

Comments

The QUOTIENT function returns the #VALUE! if the arguments are not numbers.

Examples

You are about to send your company products to customers. You have boxes you can send the products in.

boxes

You have 18 items of product A in your inventory (cell B2). The box for product A can hold up to 4 items (cell C2).

Quotient function1

How many boxes do you need for product A?

Yes, you can construct a formula for that but you don´t need to do that, there is a function in excel. Let me introduce the Quotient function.

Quotient function

The quotient function returns the integer portion of a division. Simple as that. QUOTIENT(numerator, denominator) There are two arguments, numerator is the dividend and the denominator is the divisor.

Quotient function2

The formula in cell D2:  =QUOTIENT(B2,C2) returns 4. If you divide 18 by 4, you get 4.5. The Quotient function returns 4 because  the integer part of 4.5 is 4.

Tip! There is an Integer function also in excel so this formula gives the same result: =INT(B2/C2).
Int function rounds a number down to the nearest integer.

The next question is how many products are left? Believe it or not, there is a function for that too.

Mod function

The Mod function returns the remainder after a number is divided by divisor.

mod function1

Formula in cell E2: =MOD(B2, C2)

18 divided by 4 is 4.5. The integer part of 4.5 is 4. 4 x 4 is 16. 18-16 is 2.
2 products are left.

You can use the mod function in a conditional formatting formula to highlight ever n-th row:

How to use the MOD function

The Mod function returns the remainder after a number is divided by divisor. The Mod function is short for the Modulo […]

Download excel *.xlsx file

Quotient and mod functions.xlsx