How to use the Excel QUOTIENT function

Quotient function in Excel comes under the Math and Trig category which is used for mathematical formulation and returns the integer value with a division of numerator and denominator. To Quotient, go to Insert function in the Formula menu tab and select Quotient or type equal sign and select this function. Now as per the syntax we must have both numerator and denominator in different cells. Select each value that will return the division in the whole number.

Syntax: =QUOTIENT (numerator, denominator)

The QUOTIENT function syntax has the following arguments:

  • Numerator (required) – the dividend, i.e. the number to be divided.
  • Denominator (required) – the divisor, i.e. the number to divide by.

Example: Let’s look at some Excel QUOTIENT function examples and explore how to use the QUOTIENT function as a worksheet function in Microsoft Excel:

Excel QUOTIENT function - How to use the Excel QUOTIENT function
Excel QUOTIENT function

Syntax:  =QUOTIENT(A2,B2)

Result:

QUOTIENT function - How to use the Excel QUOTIENT function
QUOTIENT function

Based on the Excel spreadsheet above, the following QUOTIENT examples would return:

Syntax: =QUOTIENT(A3,B3)
Result: 1

Syntax: =QUOTIENT(A4,B4)
Result: 4

Syntax: =QUOTIENT(A5,B5)
Result: 1

Syntax: =QUOTIENT(A6,B6)
Result: 3

Syntax: =QUOTIENT(A7,B7)
Result: 1

Syntax: =QUOTIENT(A8,B8)
Result: -5

Syntax: =QUOTIENT(A9,B9)
Result: #DIV/0!

Syntax: =QUOTIENT(A10,B10)
Result: #VALUE!

Note:

  • The function returns the #DIV/0 error if the denominator argument of the function is 0 or blank cell (considered as value 0).
  • The function returns the #VALUE! Error if the numerator argument is non – numeric.
  • The function returns the #VALUE! Error if the denominator argument is non – numeric.
  • The numerator can have the value 0 and returns Quotient as 0 for the same.
  • The arguments numerator & denominator both can have any value either rational or irrational. ( Denominator cannot be 0 )

Add a Comment

Your email address will not be published. Required fields are marked *