QUOTIENT
Applies to: Calculated column Calculated table Measure Visual calculation
Performs division and returns only the integer portion of the division result. Use this function when you want to discard the remainder of division.
Syntax
QUOTIENT(<numerator>, <denominator>)
Parameters
Term | Definition |
---|---|
numerator | The dividend, or number to divide. |
denominator | The divisor, or number to divide by. |
Return value
A whole number.
Remarks
If either argument is non-numeric, QUOTIENT returns the #VALUE! error value.
You can use a column reference instead of a literal value for either argument. However, if the column that you reference contains a 0 (zero), an error is returned for the entire column of values.
Example
The following formulas return the same result, 2.
= QUOTIENT(5,2)
= QUOTIENT(10/2,2)