The Excel QUOTIENT function returns the integer portion of a division between two supplied numbers.
The syntax of the function is:
where the arguments are as follows:
| numerator | - | The number to be divided. |
| denominator | - | The value that divides the numerator. |
The following spreadsheet shows four examples of the Excel Quotient function.
|
Formulas:
|
Results:
|
For further information on the Excel Quotient function, see the Microsoft Office website.
If you get an error from the Excel Quotient function this is likely to be one of the following:
| #DIV/0! | - | Occurs if the supplied denominator argument is zero. |
| #VALUE! | - | Occurs if any of the supplied arguments are non-numeric. |