In this Article

- QUOTIENT Function Overview
- QUOTIENT Function Syntax and Inputs:
- QUOTIENT Function
- QUOTIENT Function – Decimal Numbers
- QUOTIENT Function – Negative Numbers
- QUOTIENT Function – Divide by 0
- QUOTIENT Function – Error
- QUOTIENT Function – Finding the remainder of a division
- QUOTIENT in Google Sheets
- Additional Notes
- QUOTIENT Examples in VBA

*This Tutorial demonstrates how to use the Excel QUOTIENT Function in Excel to calculate the integer portion of division.*

## QUOTIENT Function Overview

The QUOTIENT Function Returns the integer result of dividing two numbers.

To use the QUOTIENT Excel Worksheet Function, select a cell and type:

(Notice how the formula inputs appear)

## QUOTIENT Function Syntax and Inputs:

1 |
=QUOTIENT(numerator,denominator) |

**numerator** – A number for the numerator.

**denominator** – A number for the denominator.

**QUOTIENT Function **

The QUOTIENT Function divides the number entered and returns the integer portion of their division.

1 |
=QUOTIENT(8,3) |

The QUOTIENT Function will divide 8 by 3 resulting in 2.66. Here the remainder of division is discarded and the Function returns 2.

**QUOTIENT Function – Decimal Numbers**

The QUOTIENT Function can perform division of decimal numbers & returns the integer portion of their division.

1 |
=QUOTIENT(9.5,2.6) |

**QUOTIENT Function – Negative Numbers**

The QUOTIENT Function can perform division of negative numbers & returns the integer portion of their division.

1 |
=QUOTIENT(-9,4) |

**QUOTIENT Function – Divide by 0**

The QUOTIENT Function returns an error when the second argument/denominator is zero.

1 |
=QUOTIENT(8,0) |

**QUOTIENT Function – Error**

The QUOTIENT Function returns an error when non-numeric arguments are entered.

1 |
=QUOTIENT(J, 9) |

**QUOTIENT Function – Finding the remainder of a division**

The QUOTIENT Function can be used to find out the remainder of a division.

1 |
=C3 - (C4*QUOTIENT(C3,C4)) |

Here the formula multiples the divisor/denominator with the quotient (integer portion of the division). It then subtract it from the dividend/numerator to calculate the remainder.

Note: We can also use MOD Function to find out the remainder of a division. To learn more about MOD Function, click here.

**QUOTIENT **in Google Sheets

The QUOTIENT Function works exactly the same in Google Sheets as in Excel:

## Additional Notes

Use the QUOTIENT Function to calculate the integer result after dividing two numbers.

## QUOTIENT Examples in VBA

You can also use the QUOTIENT function in VBA. Type:

`Application.Worksheetfunction.Quotient(numerator,denominator)`

For the function arguments (numerator, etc.), you can either enter them directly into the function, or define variables to use instead.

Return to the List of all Functions in Excel