Spread Formula Reference
QUOTIENT
Formula Functions > Functions M to Q > QUOTIENT

This function returns the integer portion of a division. Use this to ignore the remainder of a division.

Syntax

QUOTIENT(numerator,denominator)

Arguments

This function has these arguments:

Argument Description
numerator Numerator or dividend
denominator Denominator or divisor

Data Types

Accepts numeric data for all arguments. Returns numeric data.

Examples

QUOTIENT(B8,B10)

QUOTIENT(R8B2,R10B2)

QUOTIENT(14,4) gives the result 3

Version Available

This function is available in product version 1.0 or later.

See Also

MOD | PRODUCT | Math and Trigonometry Functions