< Go Back

Excel QUOTIENT Function

Excel QUOTIENT Function

Figure 1.  Using excel quotient function

General Formula

=QUOTIENT (Numerator, Denominator)


The QUOTIENT function in Microsoft Excel is often used to perform a division operation on two numeric values, and it’ll return the whole number only as a result, not the remainder.

There is no “division” function in Microsoft Excel which will give you with both the integer portion and the remainder.

  • To perform “division operations” wherever the integer portion and decimal are returned, use a “division formula”.
  • To return only the remainder – use the “MOD function”.

How the formula Works

The Syntax of QUOTIENT Function

A syntax refers to the procedure of the function and the function’s name, comma separators, brackets, and arguments.

The QUOTIENT function syntax is:

=QUOTIENT (dividend, divisor)

Dividend (required) – the Numerator (the numeric value written preceding the forward slash (/) in a division operation).

Divisor (required) – the Denominator (the numeric value written succeeding forward slash in a division operation).

Errors Using the QUOTIENT Function

#DIV/0! – This occurs if the divisor value is equal to zero or references a blank cell.

#VALUE! – This occurs if any argument is not a numeric value. example

Figure 2. Quotient function error


Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment