Returns the integer portion of a division operation.
פונקציה זו פועלת ב-Google Sheets בדיוק כמו ב-Excel — אותה תחביר ואותם ארגומנטים.
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)תוצאה: 3
Divides 10 by 3, resulting in 3 with a remainder of 1, which is discarded.
=QUOTIENT(-10, 3)תוצאה: -3
Divides -10 by 3, returning the integer portion -3.
The function will return a #DIV/0! error.