Excel's QUOTIENT funtion
Returns the integer portion of a division. Use this function when you want to discard the remainder of a division.
If this function is not available, and returns the #NAME? error, install and load the Analysis ToolPak add-in by following steps:
1)On the Tools menu, click Add-Ins.
2)In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.
3)If necessary, follow the instructions in the setup program.
Syntax : QUOTIENT(numerator,denominator)
Numerator - is the dividend.
Denominator - is the divisor.
Remark
If either argument is nonnumeric, QUOTIENT returns the #VALUE! error value.
Example
Formula Description (Result)
=QUOTIENT(5, 2) Integer portion of 5/2 (2)
=QUOTIENT(4.5, 3.1) Integer portion of 4.5/3.1 (1)
=QUOTIENT(-10, 3) Integer portion of -10/3 (-3)