The QUOTIENT function, one of Excel’s math functions, 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:
Note: For help with this example, see the image to the right.
- Enter the following data in cells indicated:
C1: 5
C2: 2 - Click on cell D1 - the location where the results will be displayed.
- Click on the Formulas tab of the ribbon.
- Choose Math & Trig from the ribbon to open the function drop down list.
- Click on QUOTIENT in the list to bring up the function's dialog box.
- In the dialog box, click on the Numerator line.
- Click on cell C1 on the spreadsheet.
- In the dialog box, click on the Denominator line.
- Click on cell C2 on the spreadsheet.
- Click OK in the dialog box.
- The answer 2 should appear in 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.
Related Articles
