Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Separate Quotient And Remainder in Excel (5 Easy Ways)

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.

Dataset for how to Separate Quotient and Remainder in Excel


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)

Use INT Function to Separate Quotient and Reminder in Excel

  • 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)

Determine Remainder in Excel to Separate Quotient and Remainder

  • 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)

Employ QUOTIENT Function to Separate Quotient and Remainder in Excel

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

Dragging Fill Handle to Copy Formula to Separate Quotient and Remainder in Excel

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

how to separate quotient and remainder in excel


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)

Utilize Excel TRUNC Function to Split Quotient and Reminder

  • 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)

Use MOD Function to Separate Reminder and Quotient in Excel

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

Find Quotient in Excel from Remainder to Separate Them

  • 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)

Apply QUOTIENT and MOD Functions to Find Quotient and Reminder Separately in Excel

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

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


Related Articles

Mashhura

Mashhura

Hey! Welcome to my profile. Right now, I am doing research on Microsoft Excel. I will be posting articles related to this here. My last educational degree was B.Sc in Industrial and Production Engineering from Bangladesh University of Engineering and Technology. I like to explore new things and find the best and most innovative solutions in every situation.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo