What is QUOTIENT Function in Excel?
The QUOTIENT function is one of the math functions of Excel.
It Returns the integer portion of a division.
We can find this function in Math & trig category of insert function Tab.
How to use QUOTIENT function in excel
- Click on an empty cell (like F5 )
2. Click on fx icon (or press shift+F3)
3. In the insert function tab you will see all functions
4. Select math and trig category
5. Select QUOTIENT function
6. Then select ok
7. In the function arguments Tab you will see QUOTIENT function
8. Numerator is the dividend
9. Denominator is the divisor
10. You will see results in the formula result section
Examples of QUOTIENT function in Excel
Example 1:
How to use QUOTIENT function in excel
You can see examples of QUOTIENT function below:
quotient(A2,B2) ----->>>>answer is 1
quotient(A3,B3) ----->>>>answer is 33
quotient(A4,B4) ----->>>>answer is -1
quotient(A5,B5) ----->>>>answer is #DIV/0!
quotient(A6,B6) ----->>>>answer is 0
quotient(A7,B7) ----->>>>answer is 100What is the purpose of QUOTIENT function?
It Returns the integer portion of a division.
What is the Return value of QUOTIENT function?
It returns a number.
How many arguments does QUOTIENT function have?
This function has just 2 Argument.
The argument of QUOTIENT function is number.
Numerator is the dividend.
Denominator is the divisor.
The argument of QUOTIENT function is required and not optional.
QUOTIENT(number) = number
Which version of excel supports QUOTIENT function?
This function is available for all excel versions (2003-2019)
