Returns the integer portion of a division operation.
Syntaxis
QUOTIENT(numerator, denominator)Argumenten
numeratorvereist
The dividend to be divided.
denominatorvereist
The divisor by which to divide.
The QUOTIENT function divides two numbers and discards the remainder. It is useful when you need to perform integer division without rounding the result.
=QUOTIENT(10, 3)→3Divides 10 by 3, resulting in 3 with a remainder of 1, which is discarded.
=QUOTIENT(-10, 3)→-3Divides -10 by 3, returning the integer portion -3.
Select the cell
Click on the cell where you want the result to appear.
Enter the formula
Type =QUOTIENT(numerator, denominator) replacing the arguments with your values or cell references.
The function will return a #DIV/0! error.