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. |