## Quotient, Mod and Int functions

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: Learn how the MOD function works

### Download excel *.xlsx file

Quotient and mod functions.xlsx

If you want to learn more about array formulas join Advanced excel course.

### Functions

Here is a useful feature I recently found googling for Excel solver examples. I have summed some random values from the list A1:A11 in C1. How do I find those summed numbers in C1? I am going to use Excel […]

In this post, I will provide a formula to sum values in column (Qty) where an column (Date) meets two date criteria and an additional criterion in an adjacent column (Product). I have colored the cells in column Qty that […]

Question: Hi, What type of formula could be used if you weren't using a date range and your data was not concatenated? ie: Input Value 1.78 should return a Value of B as it is between the values in Range1 […]

### 3 Responses to “Quotient, Mod and Int functions”

### Leave a Reply

**How to add a formula to your comment:**

<code>your formula</code>

**How to add VBA code to your comment:**

[vb 1="vbnet" language=","]

VBA code

[/vb]

**How to add a picture to your comment:**

Upload picture to postimage.org

Add picture link to comment.

**Contact Oscar**

You can contact me through this webpage

With INT formula you will get same result. =INT(B2/C2)

Sorry, I did not read carefully...

you also mentioned this function.

[…] More MOD examples: Learn how the MOD function works, Quotient, Mod and Int functions […]