QUOTIENT

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, run the Setup program to install the Analysis ToolPak. After you install the Analysis ToolPak, you must enable it by using the Add-Ins command on the Tools menu.

Syntax

QUOTIENT(numerator,denominator)

Numerator   is the dividend.

Denominator   is the divisor.

Remarks

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

Examples

QUOTIENT(5, 2) equals 2

QUOTIENT(4.5, 3.1) equals 1

QUOTIENT(-10, 3) equals -3