ID EN
…
#Math

QUOTIENT

Excel Functions

Returns the quotient without a remainder.

Syntax

EXCEL 
=QUOTIENT(numerator, denominator)

Arguments

Parameter Description
numerator The number to be divided.
denominator The number to divide by.

Return Value

Integer Number

Details

The QUOTIENT function returns the integer portion of division without the remainder. You can use QUOTIENT to discard the remainder after division. To perform division with a remainder, use the division operator "/". To return only the remainder, use the MOD function. QUOTIENT function takes two arguments, numerator and denominator. Numerator is the number that should be divided, and denominator is the number to divide numerator by. The number 5 divided by 2 returns 2.5, since 2 goes into 5 two and a half times: With the QUOTIENT function, the decimal portion is discarded: Other examples:

Examples

Examples

The number 5 divided by 2 returns 2.5, since 2 goes into 5 two and a half times:

EXCEL 
=5/2 // returns 2.5
Examples

With the QUOTIENT function, the decimal portion is discarded:

EXCEL 
=QUOTIENT(5,2) // returns 2
Examples

Other examples:

EXCEL 
=QUOTIENT(3,5) // returns 0
=QUOTIENT(25,5) // returns 5
=QUOTIENT(10,3) // returns 3

See Also

MOD