Edit

QUOTIENT

  • Article

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)

Related content

Math and Trig functions