QUOTIENT
TheQUOTIENT
formula in Google Sheets returns the integer portion of a division operation. It takes two parameters, the dividend
and the divisor
. The formula divides the dividend
by the divisor
and returns the quotient without the remainder.
 How to use
QUOTIENT
formula?  Examples of using
QUOTIENT
formula QUOTIENT
formula not working? Similar formulas to
QUOTIENT
Usage
Use the QUOTIENT
formula with the syntax shown below, it has 2 required parameters:
 dividend (required):
The number to be divided.  divisor (required):
The number to divide by.
Examples
Here are a few example use cases that explain how to use theQUOTIENT
formula in Google Sheets.
Splitting a total amount into equal parts
If you have a total amount that needs to be split into equal parts, you can use the QUOTIENT
formula to determine how much each part should be. For example, if you have a total of $100 that needs to be split into 5 equal parts, you can use the formula =QUOTIENT(100,5)
to get the result of $20.
Calculating the number of hours worked
If you have a total number of minutes worked and need to convert it to hours, you can use the QUOTIENT
formula. For example, if you have worked 375 minutes, you can use the formula =QUOTIENT(375,60)
to get the result of 6 hours.
Finding the number of weeks between two dates
If you have two dates and need to find the number of weeks between them, you can use the QUOTIENT
formula. For example, if you have a start date in cell A2 and an end date in cell B2, you can use the formula =QUOTIENT(B2A2,7)
to get the result of the number of weeks between the two dates.
Common Mistakes
QUOTIENT
not working? Here are some common mistakes people make when using the QUOTIENT
Google Sheets Formula:
Divide by zero error
If the divisor is 0, the formula will return a #DIV/0! error. To avoid this, make sure that the divisor is not 0.
Incorrect arguments
The QUOTIENT function requires two arguments: the dividend and the divisor. If you include more or fewer arguments, or if you use the wrong type of arguments, the formula will return an error.
Incorrect order of arguments
The order of the dividend and divisor in the QUOTIENT function matters. Make sure that you put the dividend first and the divisor second.
Related Formulas
The following functions are similar to QUOTIENT
or are often used with it in a formula:

INT
The
INT
formula rounds a given value down to the nearest integer. This formula is often used to simplify large numbers or to convert decimal values to integers. The formula takes a single parameter, the value to be rounded down. If the value is already an integer, the formula will return the same value. If the value is a decimal, the formula will round down to the nearest integer. 
MOD
The
MOD
function returns the remainder of a division operation. It takes two numeric inputs: the dividend and divisor. The result will be the remainder after the dividend has been divided by the divisor. This function is often used in financial and accounting calculations. 
ROUND
The
ROUND
formula rounds a number to a specified number of decimal places. It is commonly used to simplify large numbers or to make a number more readable. The formula can round both positive and negative numbers. If theplaces
parameter is not specified, the formula rounds to the nearest integer. 
CEILING
The
CEILING
function returns a number rounded up to the nearest multiple of a specified factor. It is commonly used to round up prices to the nearest dollar or to adjust numbers to fit into specific increments. 
FLOOR
The FLOOR formula rounds a given number down to the nearest multiple of a specified factor. It is commonly used when dealing with financial data or when working with time values. The function takes a value and an optional factor as arguments and returns the rounded down value.
Learn More
You can learn more about the QUOTIENT
Google Sheets function on Google Support.