Formulas and Functions Help
- Welcome
-
- ACCRINT
- ACCRINTM
- BONDDURATION
- BONDMDURATION
- COUPDAYBS
- COUPDAYS
- COUPDAYSNC
- COUPNUM
- CUMIPMT
- CUMPRINC
- CURRENCY
- CURRENCYCODE
- CURRENCYCONVERT
- CURRENCYH
- DB
- DDB
- DISC
- EFFECT
- FV
- INTRATE
- IPMT
- IRR
- ISPMT
- MIRR
- NOMINAL
- NPER
- NPV
- PMT
- PPMT
- PRICE
- PRICEDISC
- PRICEMAT
- PV
- RATE
- RECEIVED
- SLN
- STOCK
- STOCKH
- SYD
- VDB
- XIRR
- XNPV
- YIELD
- YIELDDISC
- YIELDMAT
-
- AVEDEV
- AVERAGE
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BETADIST
- BETAINV
- BINOMDIST
- CHIDIST
- CHIINV
- CHITEST
- CONFIDENCE
- CORREL
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COVAR
- CRITBINOM
- DEVSQ
- EXPONDIST
- FDIST
- FINV
- FORECAST
- FREQUENCY
- GAMMADIST
- GAMMAINV
- GAMMALN
- GEOMEAN
- HARMEAN
- INTERCEPT
- LARGE
- LINEST
- LOGINV
- LOGNORMDIST
- MAX
- MAXA
- MAXIFS
- MEDIAN
- MIN
- MINA
- MINIFS
- MODE
- NEGBINOMDIST
- NORMDIST
- NORMINV
- NORMSDIST
- NORMSINV
- PERCENTILE
- PERCENTRANK
- PERMUT
- POISSON
- PROB
- QUARTILE
- RANK
- SLOPE
- SMALL
- STANDARDIZE
- STDEV
- STDEVA
- STDEVP
- STDEVPA
- TDIST
- TINV
- TTEST
- VAR
- VARA
- VARP
- VARPA
- WEIBULL
- ZTEST
- Copyright
QUOTIENT
The QUOTIENT function returns the integer quotient of two numbers. Both arguments are number values.
To learn the basics about using formulas and functions, see Formulas overview and Functions overview.
QUOTIENT(dividend, divisor)
dividend: A number to be divided by another number.
divisor: A number to divide into another number. If divisor is 0, a division by 0 results and the function returns an error.
Notes
If either, but not both, the dividend or divisor is negative, the result will be negative. If the sign of both the dividend and the divisor is the same, the result will be positive.
Only the whole part of the quotient is returned. The fractional part (or remainder) is ignored.
Examples |
|---|
=QUOTIENT(5, 2) returns 2, because 5 divided by 2 is 2.5 and the fractional part is ignored. =QUOTIENT(5.99, 2) returns 2, because 5.99 divided by 2 is 2.995 and the fractional part is ignored. =QUOTIENT(-5, 2) returns -2, because -5 divided by 2 is -2.5 and the fractional part is ignored. =QUOTIENT(-6, -2) returns 3, because -6 divided by -2 is exactly 3. =QUOTIENT(5, 6) returns 0, because 5 divided by 6 is 0.833333333333333 and the fractional part is ignored. |