Sign up for free
Functions

QUOTIENT

Divides two numbers and returns only the integer part of the result, discarding any remainder. This is equivalent to performing division and then truncating the decimal portion.

Parameter List

Syntax
QUOTIENT(numerator, denominator)
numerator

The dividend (number to be divided). For example: 10, A1, or any numeric value.

denominator

The divisor (number to divide by). For example: 3, B1, or any non-zero numeric value.

More details

QUOTIENT performs integer division by dividing the numerator by the denominator and returning only the whole number portion. It's equivalent to using TRUNC(numerator/denominator). The remainder is discarded, not rounded. If the denominator is 0, returns #DIV/0! error.

Examples

QUOTIENT() returns 1