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

Get FREE Advanced Excel Exercises with Solutions!

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.


How to Divide Without Remainder in Excel: 3 Effective Methods

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


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.

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


Download Practice Workbook

You can download the practice workbook from here.


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.


Related Articles


<< Go Back to Excel MOD Function | Excel Functions | Learn Excel

What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Mehedi Hasan Shimul
Mehedi Hasan Shimul

Md. Mehedi Hasan, with a BSc in Electrical & Electronic Engineering from Bangladesh University of Engineering and Technology, holds a crucial position as an Excel & VBA Content Developer at ExcelDemy. Driven by a deep passion for research and innovation, he actively immerses himself in Excel. In his role, Mehedi not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently deliver exceptional and quality content.... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo