• Share

Discuss in my forum

# Excel QUOTIENT Function

## Using the QUOTIENT Function to Divide in Excel

Excel's Quotient Function

The QUOTIENT function can be used to divide numbers in Excel.

Unlike regular division, however, the QUOTIENT function only gives you the whole number as an answer - not the remainder.

The syntax for the QUOTIENT function is:

=QUOTIENT ( numerator , denominator )

### Example: Using Excel's QUOTIENT Function

For help with this example, see the image above.

1. Enter the following data in cells indicated:
C1: 5
C2: 2
2. Click on cell D1 - the location where the results will be displayed.

3. Click on the Formulas tab of the ribbon.

4. Choose Math & Trig from the ribbon to open the function drop down list.

5. Click on QUOTIENT in the list to bring up the function's dialog box.

6. In the dialog box, click on the Numerator line.

7. Click on cell C1 in the spreadsheet.

8. In the dialog box, click on the Denominator line.

9. Click on cell C2 on the spreadsheet.

10. Click OK in the dialog box.

11. The answer 2 should appear in cell D2.

12. When you click on cell D2, the complete function =QUOTIENT(C1,C2) appears in the formula bar above the worksheet.

Since the QUOTIENT function only returns the integer portion of the division operation, the remainder(0.5 or 1/2) is not displayed.

If you wish the remainder to be displayed as part of the answer, you can easily create your own division formula.

Ted French