The Quotient function in Google Sheets is categorized under Math. There is a chance to confuse this math function with another math function DIVIDE.

Both the function DIVIDE and QUOTIENT can be used to divide numeric values. But where the differences lie? Let me explain that below.

QUOTIENT Vs DIVIDE:

As the name denotes, the Quotient function returns the quotient after dividing numeric values. To get the quotient and remainder, use the function DIVIDE.

Even though I have explained the DIVIDE function earlier, I think it’s wise to start this tutorial with this function as it’s more common in use.

The DIVIDE function is equal to the forward slash / arithmetic operator. Before jumping into the function syntax and formula example of Quotient, here is one example using the function Divide.

For example;

=divide(9,2)

This formula would return 4.5 similar to the formula using the said arithmetic operator as follows – =9/2.

Let’s begin with the Quotient function syntax and then we can compare it with the above formula. Here we go!

Quotient Function Syntax, Purpose and Examples in Google Sheets

Syntax:

QUOTIENT(dividend, divisor)

Both the functions Divide and Quotient share the same argument.

dividend – It is the number to be divided.

divisor – It is the number to divide by (cannot equal 0).

Purpose of the Quotient Function in Google Sheets:

I have already explained the purpose between the lines above. Again just for formalities 🙂

The purpose of the Quotient function in Google Sheets is to divide numeric values. The output will be without the remainder.

Formula Examples:

=QUOTIENT(9,2)

Output: 4 (it’s 4.5 when using Divide)

As a side note, you can use the INT function together with DIVIDE function to get the output similar to the QUOTIENT. Here is that formula.

=int(divide(9,2))

or

=int(9/2)

Related Reading:

1. How to Sum, Multiply, Subtract, Divide Numbers in Google Sheets.
2. How to Sum, Avg, Count, Max, and Min in Google Sheets Query.
3. Sum, Count, Cumulative Sum Comma Separated Values in Google Sheets.
4. How to Use Arithmetic Operators in Query in Google Sheets.
5. How to Use MOD Mathematical Function in Google Sheets.