In arithmetic when we divide a number we get either of two results a quotient or a quotient with a remainder, in excel we have an inbuilt function which gives us the quotient for the division without the remainder, Quotient function is used as follows =Quotient( Value 1 /Value 2), so if we use =Quotient (12/5) we get 2 as result.
Excel Quotient Function
In this article, we will discuss Quotient in Excel. In school, we often might have enjoyed the equation of Divisor, Dividend, Remainder, and Quotient. Obviously, we all got full marks in exams for spotting what is Divisor, Quotient, Remainder, and Dividend.
Below is the example to understand Quotient in simple terms:
In equation format:
Eg: ( 3 * 5 ) + 2 = 17
After good old school days, age was over and the technology age came along, Microsoft Excel made sure we did not forget the above equation. Excel, as we know, has so many mathematical features to calculate expressions, from basic to complex with just one easy formula. So is easy to calculate Quotient.
However, MS Excel has not forgotten pals of Quotient i.e. Dividend and Divisor. In Excel, it is calculated using those two. About Remainder, well not abandoned but separated from above pals and calculated using “=MOD()”.
How to Calculate Quotient in MS Excel?
As mentioned above, the quotient is a number obtained by diving the Dividend by Divisor which is a Simple division of Numerator and Denominator.
The syntax Quotient formula in excel is as follows:
A dividend is a Numerator and a divisor is a Denominator.
Let’s see some simple examples to calculate quotient in excel.
Example #1 – Using Cell Reference
Below given is the example to calculate Quotient using cell reference:
Type “=Quotient” in cell D2 and select A2 cell as Dividend (Numerator), type Comma (,) and select B2 for Divisor (Denominator).
Here 15 is the numerator and 4 is denominator i.e. Dividend and Divisor respectively. Cell A2 is Dividend and Cell B2 is Divisor. So, the Quotient will be –
Example #2 – Using Function Arguments
Many people find it easier to type directly in MS Excel, however, we can also use Function argument feature in excel where it clearly helps in understanding the Quotient syntax.
The above image specifically shows what each element signifies and how it eventually used in Quotient function to calculate the value. Below are the step for inserting values.
- We have the following values as dividend and divisor.
- Select Cell D2(active cell) where we need the Quotient Value.
- Click on “Formulas” tab and select “Math & Trig” option from Function Library (Highlighted in Red Box)
- A drop-down appears with various mathematical excel functions, Scroll down and Select “Quotient” by clicking on it(Highlighted in Red)
- A Dialog box appears, as shown in the image below– Function Arguments, next step would be to select cell reference or input numeric values as required.
- Go to Numerator line and click on blank space and then click on Cell containing Dividend, here it is A1 and same process for Denominator to select divisor in B1.
- You can also type numeric value (eg: 4) in Denominator if you have fix Divisor.
- Then Click on “OK” and the quotient answer appears in the selected Cell i.e. D2.
This cell reference method can be used to calculate Quotient for multiple values in excel by dragging or copying for a subsequent set of numbers
Example #3 – Using Direct Numeric Values
Another way of calculating Quotient is by using direct numeric value. When we know what numeric value is. The example is given below:
Here we directly divided the dividend using divisor, without any cell reference. 15 is the numerator and 3 is denominator which in turn will give the value as 5.
Example #4 – Fix Denominator or Divisor
Sometimes while calculating quotient, we have different dividend values but a fix Divisor. We can still calculate Quotient using the example below:
Here we see that our Dividend (Numerator) is changing and we have fix Divisor (Denominator) i.e. 3.
Things to Remember
- If the numerator is less than the denominator, the final answer is zero. However, if you want decimal value, then simply use “/” division operator. Eg: “(Numerator)/(Denominator)”
- To get remainder using same Dividend and Divisor, use MOD function.
- Error Values: Quotient Function returns Error if the Dividend is divided by 0 (Zero). If your data has few cell values as zero and in a final answer you want it to stay zero or no value, then use “IFERROR”. Refer below:
This has been a guide to Quotient in Excel. Here we learn how to calculate quotient in excel using cell reference, function arguments, direct numeric values and Fix Denominator or Divisor with examples. You can learn more about excel function from the following articles –