Skip to main content

QUOTIENT

The QUOTIENT function returns the integer part of a division.

This can be useful when you need to obtain a division result, for example, in financial calculations or data analysis.

Syntax​

QUOTIENT(dividend, divisor)

ArgumentDescriptionPermitted values
dividendNumber that needs to be dividedAny number or reference to a cell containing a number
divisorThe number by which the value of the dividend argument must be dividedAny number except 0, or a reference to a cell containing a number

Examples of use​

Division of values in cells

If you have the number 20 in cell A1 and the number 4 in cell B1, you can calculate the quotient as follows:

=QUOTIENT(A1, B1)

Result: 5.

Division using constants

You can also use constants directly in functions:

=QUOTIENT(120, 25)

Result: 4.

Division by zero

If you try to divide by zero, for example:

=QUOTIENT(10, 0)

This will result in an error, as division by zero is invalid.

Result: #DIV/0!.

Notes​

The QUOTIENT function returns only the integer part of a division. If you need to obtain a fractional part, use the standard division operator “/”.