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 quotient and remainder** in Excel.

## Download Practice Workbook

You can download the practice workbook from here.

## 5 Easy Ways to Separate 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. Use INT Function to Separate Quotient and Reminder in Excel

In this first method, I will show you how you can **separate 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.

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

You can also use **the QUOTIENT function** in Excel to **separate 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. Utilize 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**.

**Read More:** **How to Divide Without Remainder in Excel (3 Effective Methods)**

### 4. Use 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:** **How to Get Remainder in Decimal in Excel (3 Suitable Ways)**

### 5. Apply 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.

**Read More:** **[Fixed!] Excel MOD Function Not Working (3 Issues with Solutions)**

## Practice Section

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

## 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. For more articles stay connected with **ExcelDemy**. If you have any questions, feel free to let me know in the comment section below.