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.


If either argument is nonnumeric, QUOTIENT returns the #VALUE! error value.


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)


  • Do not include your name, "with regards" etc in the comment. Write detailed comment, relevant to the topic.
  • No HTML formatting and links to other web sites are allowed.
  • This is a strictly moderated site. Absolutely no spam allowed.
  • Name: