How to Divide in Excel with QUOTIENT Function

If you want to divide numbers but not display the rest, use QUOTIENT function in Excel. As a result, it returns the integer part (only an integer) and not the remainder.

The information in this article applies to Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2019 for Mac, Excel 2016 for Mac, Excel for Mac 2011, and Excel Online.

Content
  1. QUOTIENT Function Syntax and Arguments
  2. Excel QUOTIENT function examples
  3. Use arrays as arguments
  4. QUOTIENT Functional Errors
  5. Use the QUOTIENT function in Excel
  6. Enter the QUOTIENT function
  7. Other ways to share in Excel

QUOTIENT Function Syntax and Arguments

The syntax for the QUOTIENT function is:

= QUOTIENT(numerator, denominator)

Counter (necessary). This one dividend † This is the number before the slash () in the division operation. This argument can be a real number or a cell reference to find the data on the worksheet.

Denominator (necessary). This one dividing line † This is the number written after the slash in the division operation. This argument can be a real number or a cell reference to find the data on the worksheet.

Excel QUOTIENT function examples

In the image above, the examples show some different ways to use the QUOTIENT function to divide two numbers compared to a division formula.

The results of the division formula in cell B4 show both the quotient (2) and the remainder (0.4), while the QUOTIENT function in cells B5 and B6 only returns an integer even if both examples share the same two numbers.

Use arrays as arguments

Another option is to use an array for one or more function arguments, as shown in line 7 above.

Function order when using arrays:

  1. The function first divides the numbers in each array:

    1. 100/2 (answer 50)

    2. 4/2 (answer 2)

    3. Counter: 50

    4. Denominator: 2

  2. The function then uses the results of the first step for its arguments in a divide (50/2) operation to arrive at a final answer of 25.

QUOTIENT Functional Errors

  • # DIV/0! occurs if the denominator argument is zero or refers to an empty cell (see line 9 in the example above).
  • # MEANING! occurs if one of the arguments is not a number (see line 8 in the example).

Use the QUOTIENT function in Excel

The steps show how to enter the QUOTIENT function and its arguments into cell B6 in the image above.

Input options for a function and its arguments include:

  • Enter full function =QUOTIENTNT(A1, B1) in cell B6.

  • Selecting a function and its arguments in the QUOTIENT function dialog box.

While you can just manually enter the entire function, many people find it easier to use the dialog box to enter the function’s arguments.

When entering a function manually, separate all arguments with commas.

Enter the QUOTIENT function

These steps cover entering the QUOTIENT function into cell B6 using the function’s dialog box.

  1. Select cell B6 to make it active. Displays the results of the formula.

  2. Select formulas

  3. Select Mathematics & Trig to open the drop-down list of functions.

  4. Select QUOTIENT in the list to open the function’s dialog box.

  5. In the dialog box, select the line Counter

  6. Select cell A1 on the sheet to enter a reference to that cell in the dialog box.

  7. In the dialog box, select the line Denominator

  8. Select cell B1 on the sheet.

  9. Select Okay in the dialog box to end the function and return to the worksheet.

Answer 2 appears in cell B6 because 12 divided by 5 has an answer containing the integer 2. The rest is discarded by the function.

When cell B6 is selected, the full function =QUOTIENTNT(A1,B1) appears in the formula bar above the worksheet.

Excel Online

The Formulas tab is not available in Excel Online. However, you can enter the QUOTIENT function manually.

  1. Select cell B6 to make it active. Displays the results of the formula.

  2. Select Insert Function to open the Insert Function dialog box.

  3. Select Mathematics and Triggers in the Select category list.

  4. Select QUOTIENT in the Select Function list.

  5. Select Okay

  6. Select cell A1 to select the counter and enter a comma (

  7. Select cell B1 to select and enter the denominator closing parenthesis (

  8. Click Enter

Answer 2 appears in cell B6 because 12 divided by 5 has an answer containing the integer 2. The rest is discarded by the function.

Other ways to share in Excel

  • Use the division formula to perform regular division operations that return an integer and a remainder.

  • Use the MOD function to return only the remainder, fractions, or decimals of a division operation.

  • Use the INT function to remove the fractional part of a division formula and round numbers to the nearest integer.

Leave a Reply

Your email address will not be published.