In this article, we will learn about how to use the QUOTIENT function function in Excel.
The QUOTIENT function is a mathematical division function which returns the integer division of the numbers given in as input.
Dividend = Divisor * Quotient + Remainder
11 = 2 * 5 + 1
The QUOTIENT function takes two argument Dividend ( numerator ) and Divisor ( denominator ) adn returns the Integer Quotient without the remainder.
Syntax for the QUOTIENT function:
numerator: number, dividend which is being divided
denominator: number, divisor which divides the dividend or the numerator
All of this might be confusing so let’s learn about the QUOTIENT function using in an example.
Here we have a list of values as Numerator and Denominator and using the Quotient function formula will get use the QUOTIENT for the numbers.
Here A2 & B2 are given as cell reference as argument to the function.
As you can see when 5 is divided by 2, Quotient comes out to be 2 and the remainder is 1.
5 = 2 * 2 + 1
Now copy the formula to other cells using the Ctrl + D shortcut or using the drop-down cell option in excel.
The above snapshot clears some doubts about the QUOTIENT function. And you might be wondering about the #DIV/0 error in the C9 cell. When any number is divided by 0 i.e. number / 0, the function returns #DIV/0 error. Below are some of the observational results about the function.
Hope this article about How to use the QUOTIENT function in Excel is explanatory. Find more articles on mathematical functions here. Please share your query below in the comment box. We will assist you.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.