QUOTIENT Function Examples in Excel, VBA, & Google Sheets

Written by

Editorial Team

Reviewed by

Steve Rynearson

Last updated on November 9, 2023
Download Example Workbook

Download the example workbook

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

QUOTIENT Main Function

QUOTIENT Function 

The QUOTIENT Function divides the number entered and returns the resulting integer portion.

=QUOTIENT(8,3)

QUOTIENT 01

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.

=QUOTIENT(9.5,2.6)

QUOTIENT 02

QUOTIENT Function – Negative Numbers

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

=QUOTIENT(-9,4)

QUOTIENT 03

QUOTIENT Function – Divide by 0

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

=QUOTIENT(8,0)

QUOTIENT 04

QUOTIENT Function – Error

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

=QUOTIENT(J, 9)

QUOTIENT 05

QUOTIENT Function – Finding the remainder of a division

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

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

QUOTIENT 06

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:

QUOTIENT Google Function

QUOTIENT Examples in VBA

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

Application.Worksheetfunction.Quotient(numerator,denominator)

AI Formula Generator

Try for Free

Excel Practice Worksheet

practice excel worksheet

Practice Excel functions and formulas with our 100% free practice worksheets!

  • Automatically Graded Exercises
  • Learn Excel, Inside Excel!

Free Download

Return to List of Excel Functions