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 |
No comments:
Post a Comment