Related Function:

The QUOTIENT function returns the integer portion of a division. 

  • This function was introduced in Excel 2013 and so is not available in earlier versions.



Note: Use this function when you want to discard the remainder of a division.


Argument Description
numerator The dividend — the number to be divided
denominator The divisor — the value that divides the numerator argument


  A B C
1 Formula Result Notes
2 =QUOTIENT(5,2) 2 Integer portion of 5/2
3 =QUOTIENT(10,3) 3 Integer portion of 10/3
4 =QUOTIENT(-10,3) -3 Integer portion of -10/3
5 0 0 0:01:23

Usage note: If you’re looking to divide numeric values and keep a remainder, you’ll want to use the “/” operator. For example, to divide 5 by 2, you would type “=5/2” (without the quotes) into a cell, which returns 2.5. The QUOTIENT function for these same numbers, QUOTIENT(5,2), returns 2.

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if either argument is nonnumeric
#DIV/0! Occurs if the denominator argument is zero
#NAME? Occurs when Analysis ToolPak add-in is not enabled