Export (0) Print
Expand All
1 out of 4 rated this helpful - Rate this topic

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.


QUOTIENT(<numerator>, <denominator>)

Term

Definition

numerator

The dividend, or number to divide.

denominator

The divisor, or number to divide by.

A whole number.

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.

The following formulas return the same result, 2.

=QUOTIENT(5,2)
=QUOTIENT(10/2,2)
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.