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)
Argument |
Description |
Permitted values |
|---|---|---|
dividend |
Number that needs to be divided |
Any number or reference to a cell containing a number |
divisor |
The number by which the value of the dividend argument must be divided |
Any 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 “/”.