Share via


QUOTIENT Function

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)

See Also

Other Resources

Math and Trig Functions (DAX)