Returns the integer portion of a division operation.
Hàm này hoạt động trong Google Sheets giống như trong Excel — cùng cú pháp và đối số.
QUOTIENT(numerator, denominator)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)Kết quả: 3
Divides 10 by 3, resulting in 3 with a remainder of 1, which is discarded.
=QUOTIENT(-10, 3)Kết quả: -3
Divides -10 by 3, returning the integer portion -3.
The function will return a #DIV/0! error.