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.

**Table of Contents**Expand

## 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)`

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

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

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

**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**