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