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:
Example: Using Excel's QUOTIENT Function
For help with this example, see the image above.
- Enter the following data in cells indicated:
- 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 in 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.
- 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.