**Excel QUOTIENT Function**

*Figure 1. Using excel quotient function*

**General Formula**

*=QUOTIENT (Numerator, Denominator)*

**Justification**

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*

## Leave a Comment