Home ยป Functions

QUOTIENT Function in Excel – Find Quotient by Division

In one of our previous blogs, we had learned how to use the MOD excel function to find the remainder by dividing one number with another number in excel. In this tutorial, we would learn how to divide a number in excel for finding a quotient after division by using a function.

Similar to the MOD formula, the QUOTIENT formula is also an excel mathematical division formula.

Let us learn different aspects of the excel QUOTIENT formula, including its purpose, syntax, arguments, and example.

Here we go ๐Ÿ˜Ž

When to Use QUOTIENT Function in Excel

The Excel QUOTIENT function is a math/trig formula that is used to get and extract the quotient value by dividing a number (dividend) by another number (divisor) in excel. The term dividend denotes the numerator and divisor denotes the denominator part.

In other words, this function returns the integer part of the result of division.

As a result, this formula returns a whole number.

Syntax and Arguments

=QUOTIENT(numerator, denominator)

There are two arguments of the QUOTIENT excel formula, as explained below:

  • numerator – In this argument, enter the number to divide (i.e. the dividend part).
  • denominator – In this argument, specify the number to divide the numerator with (i.e. the divisor part).

QUOTIENT Excel Formula Examples

In this section, we would see few basic examples of using QUOTIENT function in Excel.

Let’s say you want to divide the number 10 with 3 and find the integer/quotient value.

To do so, simply put the numerator argument as 10 and the denominator argument as 3 in the QUOTIENT formula.

=QUOTIENT(10,3)

As a result, excel would return the result as 3 (i.e. the integer value by division).

Infographic - QUOTIENT Formula Function in Excel

Similarly, the formula =QUOTIENT(20,4) would return 5.

Using QUOTIENT function in Excel Examples

Another Way for Finding Quotient in Excel

Instead of using the QUOTIENT formula, you may also use the INT function in excel to find the integer value by division in excel.

=INT(10/3)

As a result, excel returns the quotient value as 3.

Finding Quotient Using INT Function in Excel

Explanation – In the above formula, excel firstly divides 10 by 3 and returns the result 3.33333333. Then, the INT function extracts the integer part from 3.33333333 which is ‘3’.

Do Not Miss These Points

  • You can either enter the numerator and denominator values manually (as learned above), or give it as a cell reference or result of some formula. See the image below:
QUOTIENT Function Using Cell Reference
  • The QUOTIENT function will return the #DIV/0 error when the denominator argument is either zero (0) or a blank cell. This is so because mathematically you cannot divide any number by zero (0).

    Learn more about excel formula errors and how to resolve excel errors here.
Division by Zero or Blank Cell - DIV error
  • Similarly, the QUOTIENT formula will return the #VALUE! error if either numerator or denominator is a non-numeric value (i.e. text value). See the image below:
Dividend or Divisor Non Numeric Value #VALUE!
  • When numerator is zero (0), the QUOTIENT return value will also be zero (0).
QUOTIENT result when numerator is Zero

Thank You ๐Ÿ™‚

Leave a Comment