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

How to Divide Without Remainder in Excel (3 Effective Methods)

Division is a very important mathematical operation. When a number (dividend) can’t be divided exactly by another number (divisor) then there remains a remainder. In that case, the result becomes a number with a fraction. We can easily remove the fractional part and get the quotient in Excel. In this article, I will show 3 effective methods to divide without remainder in Excel.


Download Practice Workbook

You can download the practice workbook from here.


3 Effective Methods to Divide Without Remainder in Excel

We can divide a number without remainder in Excel following different methods. Here, I will show 3 effective methods to divide a number and get the quotient.


1. Use QUOTIENT Function

In this section, I will use the QUOTIENT function of Excel to divide without remainder. For demonstration, I have used a dataset containing Dividend, Divisor and Quotient.

excel divide without remainder


1.1 Apply Numeric Value to Divide Without Remainder in Excel

We can use dividend and divisor numbers directly as the arguments of the QUOTIENT function. Let’s walk through the procedures.

  • First, write the following formula in Cell D5 and press Enter.
=QUOTIENT(112,5)

Use QUOTIENT Function

In the formula, I have given 122 (dividend) and 5 (divisor) as the argument of the QUOTIENT function.
  • After that, drag the Fill Handle down to Cell D10.
  • Finally, you will get results like the picture below.


1.2 Use Cell Reference to Perform Division Without Remainder

Instead of directly including the numbers as the arguments of the QUOTIENT function, we can use cell reference also. I am showing the stepwise procedure to do that.

  • First, write the following formula in Cell D5 and press Enter.
=QUOTIENT(B5,C5)

  • Further, use the AutoFill option of Excel to copy the formula in the cells below.
  • Consecutively, we will see the result without the remainder in each cell.

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


2. Apply TRUNC Function

Another way to divide without remainder is to round the fractional result by using the TRUNC function. I am showing the stepwise procedures to do that in the following section.

  • First, write the following formula in Cell D5 and hit Enter.
=TRUNC(B5/C5)
  • Afterward, use the Fill Handle to copy the formula in the following cells.
  • Finally, we will see the division result without the remainder.

Apply TRUNC Function

In the formula, the TRUNC function removes the fractional part which is the remainder of the result of division (B5/C5).

3. Insert ROUNDDOWN Function

We can also use the ROUNDDOWN function of Excel to remove the fractional part of the division result and get the quotient value. Follow the stepwise procedures given below.

  • First, write the following formula in Cell D5.
=ROUNDDOWN(B5/C5,0)
  • Then, hit Enter.
  • Further, use the Fill Handle to copy the formula in the following cells.
  • Finally, we will see the results without the fractional part in each cell.

excel divide without remainder result

In the formula, the ROUNDDOWN function removes the fractional part from the division value (B5/C5) as we included 0 as the argument.

Read More: Excel VBA: How to Divide Without Remainder (2 Easy Ways)


How to Find Remainder in Excel

When a dividend number isn’t completely divisible by the divisor, there remains a remainder. In this section, I will show the method to find the remainder in Excel. Follow the stepwise procedures given below.

  • First, write the following formula in Cell D5.
=MOD(B5,C5)
  • Then, press Enter.
  • Further, use the Fill Handle to copy the formula in the cells below.
  • Finally, we will see the remainder for each division.

How to Find Remainder in Excel

In the formula, the MOD function takes the dividend value (B5) and divisor value (C5) as arguments and gives the remainder directly.

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


Conclusion

Sometimes we want to get a division result without the fractional part i.e. division without remainder. Here, I have shown 3 effective methods to divide without remainder in Excel. If you have faced any problems following the procedures, leave a comment. Visit our ExcelDemy Website for more articles regarding Excel.


Related Articles

Mehedi Hasan Shimul

Mehedi Hasan Shimul

Hi! I am Mehedi Hasan Shimul. As I am an Engineer solving different problems with the help of Excel amuses me. I write Excel related different problem solving articles here. Hope it will help you.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo