QUOTIENT

This function divides the two arguments passed and returns the quotient of the division. It differs from the Quotient function of Excel in the way it does division.

Syntax

= QUOTIENT(dividend, divisor)

Parameters

Dividend

A number which is being divided. The number can be specified as an integer (e.g., 37), as a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice).

Divisor

A number which divides. The number can be specified as an integer (e.g., 37), as a decimal value (e.g., 37.48), as a string, or as the value of a variable (e.g, UnitPrice).

Return Type

Decimal number.

In the case of an error, the function displays an error message: “QUOTIENT (dividend, divisor): Error message”

The function can be used in combination with other functions.

Examples

Example

Returns

= QUOTIENT(-3.75, -2)

2

= QUOTIENT(3.75, -2)

-2

= QUOTIENT(“$3.75”, 2)

2

= QUOTIENT(UnitPrice, Quantity)

The quotient value of the division

= QUOTIENT(“abcd”, “efg”)

Displays message “QUOTIENT(abcd, efg): Input string was not in a correct format.”

= QUOTIENT(POWER(UnitPrice, 2), 3)

The quotient of division between the square of UnitPrice and the number 3.

= MAX(QUOTIENT(UnitPrice, 2), 1)

The maximum value among quotient of division between UnitPrice and the number 2, and the number 1.