When you divide a number by another number it returns a quotient and a reminder. If you are looking for a way to separate these two in Excel then you are in the right place. The main objective of this article is to explain how to separate the quotient and remainder in Excel.

Here, I have taken the following dataset to explain this article. This dataset contains 2 columns, **Dividend**, and** Divisor**. I will use this dataset to describe how to separate quotient and remainder in Excel in 5 different ways.

## 1. Using INT Function to Separate Quotient and Reminder in Excel

In this first method, I will show you how you can separate the quotient and remainder in Excel using the **INT **function. Letâ€™s explore the steps.

### Step-01: Find Quotient in Excel

In this step, I will show you how to find the **Quotient** in Excel.

- Firstly, select the cell where you want the
**Quotient**. Here, I selected**Cell D5**. - Secondly, in
**Cell D5**write the following formula.

`=INT(B5/C5)`

- Thirdly, press
**Enter**to get the**Quotient**.

**ðŸ”Ž** **How Does the Formula Work?**

**B5/C5:**Here, the formula**divides**the value in**Cell B5**by the value in**Cell C5**.**INT(B5/C5):**Now, the**INT**function will return the**integer**part of the result.

- After that, drag the
**Fill Handle**down to copy the formula.

- Finally, you can see that I have copied the formula to the other cells and got the
**Quotients**.

### Step-02: Determine Remainder in Excel

Here, I will show you how to determine the **Remainder** from the **Quotient** in Excel.

- To begin with, select the cell where you want the
**Remainder**. - Then, write the following formula in that selected cell.

`=B5-(D5*C5)`

- After that, press
**Enter**to get the result.

**ðŸ”Ž** **How Does the Formula Work?**

**D5*C5:**Here, I**multiplied**the**Quotient**by the**Divisor**.**B5-(D5*C5):**Now, the formula subtracts the result from the**Dividend**.

- Further, drag the
**Fill Handle**down to copy the formula to the other cells.

- Lastly, you can see that I have copied the formula to all the other cells and got my desired output.

**Read More:** How to Get Remainder in Decimal in Excel

## 2. Employing QUOTIENT Function to Separate Quotient and Remainder in Excel

You can also use the** QUOTIENT **functionÂ in Excel to separate the quotient and remainder. The **QUOTIENT** function returns the integer portion of a division. Letâ€™s see the steps of this calculation.

**Steps:**

- First, select the cell where you want to calculate the
**Quotient**. Here, I selected**Cell D5**. - Next, write the following formula in
**Cell D5**.

`=QUOTIENT(B5,C5)`

- Afterward, press
**Enter**and you will get the**Quotient**.

Here, in the **QUOTIENT** function, I selected **Cell B5** as the **numerator** and **Cell C5** as the **denominator**. Now, the formula returns the integer part of the division.

- Then, drag the
**Fill Handle**down to copy the formula to the other cells.

- Here, you can see that I have copied the formula to all the other cells and got the
**Quotient**for each data.

- Finally, find the
**Remainder**by following Step-02 from**Method-01**.

## 3. Utilizing Excel TRUNC Function to Split Quotient and Reminder

The** TRUNC **functionÂ removes the fraction part of a number. You can also use the **TRUNC** function to split the quotient and remainder in Excel. Let me show you the steps.

**Steps:**

- In the beginning, select the cell where you want the
**Quotient**. Here, I selected**Cell D5**. - Next, in
**Cell D5**write the following formula.

`=TRUNC(B5/C5)`

- After that, press
**Enter**to get the result.

**ðŸ”Ž** **How Does the Formula Work?**

**B5/C5:**Here, I**divided**the**Dividend**by the**Divisor**.**TRUNC(B5/C5):**Now, in the**TRUNC**function, I selected**B5/C5**as the number. The formula removes the fraction part of this number.

- Then, drag the
**Fill Handle**to copy the formula to the other cells.

- Now, you can see that I have copied the formula to the other cells.

- In the end, calculate the
**Remainder**by following Step-02 from**Method-01**.

## 4. Using MOD Function to Separate Reminder and Quotient in Excel

Here, I will show you how to separate remainder and quotient in Excel using the** MOD **function. To begin with, I will use the **MOD** function to calculate the **remainder**, and then I will calculate the **quotient** from the **remainder**. Letâ€™s see the steps.

### Step-01: Calculate Remainder in Excel

In this step, I will calculate the **Remainder** in Excel.

- Firstly, select the cell where you want the
**Remainder**. - Secondly, write the following formula in that selected cell.

`=MOD(B5,C5)`

- Thirdly, press
**Enter**and you will get the Remainder.

Here, in the **MOD** function, I selected **Cell B5** as the number and **Cell C5 **as the divisor. The formula returns the remainder of these two numbers after division.

- After that, drag the
**Fill Handle**down to copy the formula.

- Finally, you can see that I have copied the formula to the other cells and got
**Remainder**for each data.

### Step-02: Find Quotient in Excel

Now, I will find the **Quotient** from the **Remainder** I calculated in the previous step.

- In the beginning, select the cell where you want the
**Quotient**. Here, I selected**Cell E5**. - Then, in
**Cell E5**write the following formula.

`=(B5-D5)/C5`

- After that, press
**Enter**to get the**Quotient**.

**ðŸ”Ž** **How Does the Formula Work?**

**(B5-D5):**Here, I**subtracted**the**Remainder**from the**Dividend**.**(B5-D5)/C5:**Now, the formula divides the result by the**Divisor**.

- Next, drag the
**Fill Handle**down to copy the formula to the other cells.

- In the end, you can see that I have copied the formula to the other cells and got my desired results.

**Read More:** [Fixed!] Excel MOD Function Not Working

## 5. Applying QUOTIENT and MOD Functions to Find Quotient and Reminder Separately

In this method, I will use the **QUOTIENT** function to find out the **Quotient** and the **MOD** function to determine the **Remainder** in Excel. Letâ€™s see the steps.

**Steps:**

- Firstly, select the cell where you want the
**Quotient**. - Secondly, write the following formula in that selected cell.

`=QUOTIENT(B5,C5)`

- Thirdly, press
**Enter**to get the result.

Here, in the **QUOTIENT** function, I selected **Cell B5** as the **numerator** and **Cell C5** as the **denominator**. Now, the formula returns the integer part of the division.

- After that, drag the
**Fill Handle**down to copy the formula to the other cells.

- Next, select the cell where you want the
**Remainder**. - Then, write the following formula in that selected cell.

`=MOD(B5,C5)`

- Afterward, press
**Enter**and you will get the**Remainder**.

Here, in the **MOD **function, I selected **Cell B5** as the** number **and **Cell C5** as the **divisor**. The formula returns the **remainder** of these two numbers after division.

- Lastly, drag the
**Fill handle**down to copy the formula to the other cells.

## Practice Section

Here, I have provided a practice sheet for you to practice how to separate quotient and remainder in Excel.

**Download Practice Workbook**

You can download the practice workbook from here.

## Conclusion

So, you have reached the end of my article. Here, I tried to explain how to separate quotient and remainder in Excel in 5 different ways. I hope this article was helpful to you.Â If you have any questions, feel free to let me know in the comment section below.