- Formula Reference
- Contacting Us
- Getting Technical Support
- Formula Overview
-
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
-
Functions M to Q
- MAKEARRAY
- MAP
- MATCH
- MAX
- MAXA
- MAXIFS
- MDETERM
- MDURATION
- MEDIAN
- MID
- MIDB
- MIN
- MINA
- MINIFS
- MINUTE
- MINVERSE
- MIRR
- MMULT
- MOD
- MODE
- MODE.MULT
- MODE.SNGL
- MONTH
- MONTHSPARKLINE
- MROUND
- MULTINOMIAL
- MUNIT
- N
- NA
- NEGBINOM.DIST
- NEGBINOMDIST
- NETWORKDAYS
- NETWORKDAYS.INTL
- NOMINAL
- NORM.DIST
- NORM.INV
- NORM.S.DIST
- NORM.S.INV
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- NOT
- NOW
- NPER
- NPV
- NUMBERVALUE
- OCT2BIN
- OCT2DEC
- OCT2HEX
- ODD
- ODDFPRICE
- ODDFYIELD
- ODDLPRICE
- ODDLYIELD
- OFFSET
- OR
- PARETOSPARKLINE
- PDURATION
- PEARSON
- PERCENTILE
- PERCENTILE.EXC
- PERCENTILE.INC
- PERCENTRANK
- PERCENTRANK.EXC
- PERCENTRANK.INC
- PERMUT
- PERMUTATIONA
- PHI
- PI
- PIESPARKLINE
- PMT
- POISSON
- POISSON.DIST
- POWER
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PROB
- PRODUCT
- PROPER
- PV
- QUARTILE
- QUARTILE.EXC
- QUARTILE.INC
- QUOTIENT
- Functions R to S
- Functions T to Z
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.