The Excel QUOTIENT Function
Home »
Excel-Built-In-Functions »
Excel-Math-Functions »
Excel-Quotient-Function
Search this site:
|
|
The Excel QUOTIENT function returns the integer portion of a division between two supplied numbers.
The format of the function is :
QUOTIENT( Numerator, Denominator )
where the arguments are as follows:
| Numerator |
The number to be divided |
| Denominator |
The value that divides the Numerator argument |
Examples
The following spreadsheet shows four examples of the Excel Quotient function.
The spreadsheet on the left shows the format of the functions, and the spreadsheet on the right shows the results.
Formulas
| |
A |
B |
| 1 |
|
=QUOTIENT( 5, 2 ) |
| 2 |
|
=QUOTIENT( 10, 2.2 ) |
| 3 |
5.5 |
=QUOTIENT( A3, 2.667 ) |
| 4 |
-7 |
=QUOTIENT( A4, 2 ) |
|
Results
| |
A |
B |
| 1 |
|
2 |
| 2 |
|
4 |
| 3 |
5.5 |
2 |
| 4 |
-7 |
-4 |
|
Further information on the Excel Quotient function can be found on the
Microsoft Office website.
Common Errors
If you get an error from your Excel Quotient function this is likely to be one of the following :
|
#NAME?
|
-
|
Occurs when Analysis ToolPak add-in is not enabled in your Excel.
You will need to enable the add-in if you want to use the Excel Quotient function.
To do this in Excel 2003 :
- From the Tools drop-down menu, select the option Add-Ins ...
- An 'Add-Ins' window will pop up. From this, select the option Analysis ToolPak and click OK
To do this in Excel 2007 :
- Click the Microsoft button on the top left of your spreadsheet and select
the Excel Options button
- From the menu on the left hand side, select Add-Ins
- In the 'Manage:' box, select Excel Add-ins and click Go...
- An 'Add-Ins' window will pop up. From this, select the option Analysis ToolPak
and click OK
|
|
#DIV/0!
|
-
|
Occurs if the Denominator argument is zero.
|
