QUOTIENT function

Overview

QUOTIENT is a function of the Math and Trigonometry category that returns the integer portion of a division. It divides one number (dividend) by another (divisor) and discards the remainder by truncating toward zero.

Usage

Syntax

QUOTIENT(dividend, divisor) => quotient

Argument descriptions

• dividend (number, required). The number to be divided.
• divisor (number, required). The number by which to divide the dividend.

Additional guidance

• QUOTIENT returns the integer part of the division and ignores any remainder. For negative results, it truncates toward zero.

Returned value

QUOTIENT returns a number that is the integer portion of the division of the dividend by the divisor.

Error conditions

• In common with many other IronCalc functions, QUOTIENT propagates errors that are found in its arguments.
• If no argument, or more than two arguments, are supplied, then QUOTIENT returns the #ERROR! error.
• If either argument is not (or cannot be converted to) a number, then QUOTIENT returns the #VALUE! error.
• If the value of the divisor argument is 0, then QUOTIENT returns the #DIV/0! error.
• For more information about the different types of errors that you may encounter when using IronCalc functions, visit our Error Types page.

Details

• QUOTIENT corresponds to truncating the exact quotient toward zero:

$$\mathrm{QUOTIENT}(n,d)=\mathrm{TRUNC}\left({\displaystyle \frac{n}{d}}\right),d\ne 0$$

This differs from using INT(n/d) when the quotient is negative, because INT rounds down toward −∞, whereas TRUNC and QUOTIENT truncate toward zero.

Links

• For more information about the quotient, visit Wikipedia's Quotient page.
• See also IronCalc's MOD function.
• Visit Microsoft Excel's QUOTIENT function page.
• Both Google Sheets and LibreOffice Calc provide versions of the QUOTIENT function.