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.
= QUOTIENT(dividend, divisor)
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). |
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.
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. |