Returns the integer portion of a division operation.
Söz dizimi
QUOTIENT(numerator, denominator)Bağımsız değişkenler
numeratorzorunlu
The dividend to be divided.
denominatorzorunlu
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.