QUOTIENT function

Returns the integer portion of a division. Use this function when you want to discard the remainder of a division.

Syntax

QUOTIENT(numerator,denominator)

Argument	Description	Remarks
numerator	The dividend.	If this argument is nonnumeric, this function returns the #VALUE! error value.
denominator	The divisor.	If this argument is nonnumeric, this function returns the #VALUE! error value.

Example

To make the following example easier to understand, you can copy the data to a blank sheet and then enter the function underneath the data. Do not select the row or column headings (1, 2, 3... A, B, C...) when you copy the sample data to a blank sheet.

A	B
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)

See also
MOD function
List of all functions (by category)

Share your feedback about this topic

Rate this content: