Author: Oscar Cronquist Article last updated on May 02, 2018

The quotient function returns the integer portion of a division.

Example, 5/2 = 2.5. The integer is 2.

### Excel Function Syntax

QUOTIENT(numerator, denominator)

### Arguments

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

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

The following formula is equivalent to the QUOTIENT function:

=INT(numerator/denominator)

### Examples

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

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). 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.

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.

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 […]