Math and Trignometric - QUOTIENT Function



Description

The QUOTIENT function returns the integer portion of a division. Use this function when you want to discard the remainder of a division.

Syntax

QUOTIENT (numerator, denominator)

Arguments

Argument Description Required/Optional
Numerator The dividend. Required
Denominator The divisor. Required

Notes

  • If you want to divide numeric values and keep a remainder use the "/" operator as there is no DIVIDE Function in Excel.

  • For example, to divide 5 by 2, you would type "=5/2" (without the quotes) into a cell, which returns 2.5. The QUOTIENT Function for these same numbers QUOTIENT (5, 2) returns 2.

  • If either of the arguments is nonnumeric, QUOTIENT returns the #VALUE! error value.

  • If the specified denominator is zero, QUOTIENT returns the #DIV/0! error value.

Applicability

Excel 2007, Excel 2010, Excel 2013, Excel 2016

Example

QUOTIENT Function
advanced_excel_math_trigonometric_functions.htm
Advertisements