This article describes the formula syntax and usage of the QUOTIENT function in Microsoft Excel.
Tip: If you want to divide numeric values, you should use the "/" operator as there isn't a DIVIDE function in Excel. For example, to divide 5 by 2, you would type =5/2 into a cell, which returns 2.5. The QUOTIENT function for these same numbers =QUOTIENT(5,2) returns 2, since QUOTIENT doesn't return a remainder. For other ways to divide numbers, see Multiply and divide numbers.
Description
Returns the integer portion of a division. Use this function when you want to discard the remainder of a division.
Syntax
QUOTIENT(numerator, denominator)
The QUOTIENT function syntax has the following arguments:
-
Numerator Required. The dividend.
-
Denominator Required. The divisor.
Remark
If either argument is nonnumeric, QUOTIENT returns the #VALUE! error value.
Example
Copy the example data in the following table, and paste it in cell A1 of a new Excel worksheet. To toggle between viewing the formulas and the results, press F2. If you need to, you can adjust the column widths to see all the data.
|
Formula |
Description |
Result |
|---|---|---|
|
=QUOTIENT(5, 2) |
Integer portion of 5/2 |
2 |
|
=QUOTIENT(4.5, 3.1) |
Integer portion of 4.5/3.1 |
1 |
|
=QUOTIENT(-10, 3) |
Integer portion of -10/3 |
-3 |