1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel 2007 QUOTIENT Function

By , About.com Guide

Excel's Quotient Function

Excel's Quotient Function

© Ted French

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.

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

More Spreadsheets Quick Tips
Explore Spreadsheets
About.com Special Features

The Best Web Trends of the Decade

A look back at the best innovations, ideas and technologies over the last 10 years, More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Functions
  5. Math Functions
  6. QUOTIENT Function - Excel QUOTIENT Function - Use the Excel QUOTIENT Function

©2009 About.com, a part of The New York Times Company.

All rights reserved.