# How to use the QUOTIENT function

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

### Comments

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

The following formula is equivalent to the QUOTIENT function:

*numerator/denominator)*

#### What's on this webpage

- How to remove decimals from a division?
- How to remove decimals from a number?
- How to calculate the remainder from a division?
- Is there a division function in Excel?
- How do you divide and round up in Excel?
- How to find divisors of a number without remainders?
- How to create a repeating sequence
- Get Excel file

## 1. How to remove decimals from a division?

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 build a formula for that but you don't need to do that, there is a function in Excel. Let me introduce the Quotient function.

The quotient function returns the integer portion of a division. Simple as that.

QUOTIENT(*numerator*, *denominator*)

There are two arguments, the *numerator *is the dividend and the *denominator* is the divisor.

The formula in cell D2:

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.

## 2. How to remove decimals from a number?

There is an Integer function also in excel so this formula gives the same result:

The INT function rounds a number down to the nearest integer.

## 3. How to calculate the remainder?

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

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

Formula in cell E2:

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 every n-th row:

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

## 4. Is there a division function in Excel?

There is no division function in Excel, however, you can use the slash character to calculate a division. The image above demonstrates a formula in cell C5 that divides the number in cell C2 with the number in cell C3.

Formula in cell C5:

C2 and C3 are cell references.

C2/C3

becomes

100/5

and returns 20 in cell C5.

## 5. How do you divide and round up in Excel?

The image above shows a formula in cell C5 that divides two numbers and then rounds up the result.

Formula in cell C5:

### Explaining formula in cell C5

#### Step 1 - Division

The slash character lets you divide two numbers in an Excel formula.

C2/C3

becomes

100/6

and returns approx 16.6666666666667.

#### Step 2 - Round the number up to the nearest integer

The ROUNDUP function calculates a number rounded up based on the number of digits to which you want to round the number.

ROUNDUP(*number*, *num_digits*)

ROUNDUP(C2/C3,0)

becomes

ROUNDUP( 16.6666666666667,0)

and returns 17.

## 6. How to find divisors of a number that return no remainders?

The formula in cell C4 shown in the image above is a dynamic array formula that automatically spills values to cells below. It calculates all divisors that can be used so the result returns a whole number based on the dividend specified in cell C2.

Example, number 5 returns no remainders. 100/5 = 20. The result is a whole number. Change the number in cell C2 and Excel automatically calculates divisors in cell C4 and cells below. There is a dividend limit of 1048576, you can't go higher than that.

Excel 365 formula in cell C4:

The following formula is an array formula, it works for all previous Excel versions and returns the same numbers as the Excel 365 formula.

Array formula for previous Excel versions:

### How to enter an array formula

- Double press with left mouse button on with left mouse button on cell C4.
- Paste the formula.
- Press and hold CTRL + SHIFT keys simultaneously.
- Press Enter once.
- Release all keys.

Copy cell C4 and paste to cells below as far as needed. This is required if you are using the array formula.

### Explaining Excel 365 formula in cell C4

#### Step 1 - Create a sequence

The SEQUENCE function returns an array containing a sequence of numbers.

SEQUENCE(C2)

becomes

SEQUENCE(100)

and returns {1; 2; 3; ... 98; 99; 100}. Not all numbers are shown in this sequence.

#### Step 2 - Calculate remainders

The MOD function returns the remainder of a division.

MOD($C$2,SEQUENCE($C$2))

becomes

MOD(100, {1; 2; 3; ... 98; 99; 100})

and returns {0 ;0 ;1 ; ... ; 2; 1; 0}.

#### Step 3 - Create a logical expression

The equal sign allows you to compare the numbers in the array to 0 (zero). The result is boolean values TRUE or FALSE.

MOD(C2,SEQUENCE(C2))=0

becomes

{0 ;0 ;1 ; ... ; 2; 1; 0}=0

and returns {TRUE ;TRUE ;FALSE; ... ; FALSE; FALSE; TRUE }.

#### Step 4 - Filter values based on logical expression

The FILTER function lets you extract values/rows based on a condition or criteria.

FILTER(SEQUENCE(C2), MOD(C2,SEQUENCE(C2))=0)

becomes

FILTER(SEQUENCE(C2), {TRUE ;TRUE ;FALSE; ... ; FALSE; FALSE; TRUE })

becomes

FILTER({1; 2; 3; ... 98; 99; 100}, {TRUE ;TRUE ;FALSE; ... ; FALSE; FALSE; TRUE })

and returns {1; 2; 4; 5; 10; 20; 25; 50; 100}.

## 7. How to create a repeating sequence

The image above demonstrates a formula that returns repeating numbers in a sequence. The second argument determines how many times a number is repeated before moving on to the next number.

Formula in cell B3:

Change the formula to this if you want the sequence to start with 1 instead of 0 (zero).

### Explaining formula in cell B3

#### Step 1 - Calculate a number that changes based on a relative and absolute cell ref

The ROWS function returns a number representing the number of rows in cell reference. Cell ref $A$1:A1 is a growing cell reference that changes when you copy the cell and paste to cells below.

It contains an absolute ($A$1) indicated by the dollar signs and a relative part (A1).

ROWS($A$1:A1)-1

becomes

1-1

amd returns 0 (zero).

#### Step 2 - Calculate quotient

QUOTIENT(*numerator*, *denominator*)

QUOTIENT(ROWS($A$1:A1)-1,3)

becomes

QUOTIENT(0,3)

and returns 0 (zero) in cell B3.

### 'QUOTIENT' function examples

The following 13 articles have formulas containing the QUOTIENT function.

Question: How do I create a list of dates with blanks between each quarter? (Q1, Q2, Q3 and Q4) Answer: […]

Excelxor is such a great website for inspiration, I am really impressed by this post Which numbers add up to […]

Can someone explain to me why this happens? This example is working. FREQUENCY function returns {2; 1; 1}. 2 values (0.1 and […]

Color odd months Conditional formatting formula: =MOD(MONTH($B6),2) Explaining CF formula in cell B6 Step 1 - Calculate number of month The […]

I found an old post that I think is interesting to write about today. Think of two overlapping ranges, it […]

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

I discussed the difference between permutations and combinations in my last post, today I want to talk about two kinds […]

This article demonstrates formulas that rearrange values in a cell range to a single column. Table of Contents Rearrange cells […]

The picture above shows data presented in only one column (column B), this happens sometimes when you get an undesired […]

This article demonstrates a formula that sorts items arranged horizontally based on the adjacent numbers, every other column contains a […]

This article explains how to build an array formula that sums numerical ranges. Example, I want to know how to […]

Mark G asks in Create a random playlist in excel: Can this example be modified to create a true round-robin […]

What's on this page Reverse text Insert random characters Convert letters to numbers How to shuffle characters in the alphabet […]

### Functions in 'Math and trigonometry' category

The MOD function function is one of many functions in the 'Math and trigonometry' category.

### 3 Responses to “How to use the QUOTIENT function”

### Leave a Reply

### How to comment

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

<code>Insert your formula here.</code>

**Convert less than and larger than signs**

Use html character entities instead of less than and larger than signs.

< becomes < and > becomes >

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

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

Put your VBA code here.

[/vb]

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

Upload picture to postimage.org or imgur

Paste image link to your comment.

**Contact Oscar**

You can contact me through this contact form

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