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.
