Formulas and Functions

Table of Contents

Welcome
Intro to formulas and functions
- DATE
- DATEDIF
- DATEVALUE
- DAY
- DAYNAME
- DAYS360
- EDATE
- EOMONTH
- HOUR
- MINUTE
- MONTH
- MONTHNAME
- NETWORKDAYS
- NOW
- SECOND
- TIME
- TIMEVALUE
- TODAY
- WEEKDAY
- WEEKNUM
- WORKDAY
- YEAR
- YEARFRAC
- BASETONUM
- BESSELJ
- BESSELY
- BIN2DEC
- BIN2HEX
- BIN2OCT
- CONVERT
- DEC2BIN
- DEC2HEX
- DEC2OCT
- DELTA
- ERF
- ERFC
- GESTEP
- HEX2BIN
- HEX2DEC
- HEX2OCT
- NUMTOBASE
- OCT2BIN
- OCT2DEC
- OCT2HEX
- 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
- AND
- FALSE
- IF
- IFERROR
- IFS
- ISBLANK
- ISDATE
- ISERROR
- ISEVEN
- ISNUMBER
- ISODD
- ISTEXT
- NOT
- OR
- TRUE
- ABS
- CEILING
- COMBIN
- EVEN
- EXP
- FACT
- FACTDOUBLE
- FLOOR
- GCD
- INT
- LCM
- LN
- LOG
- LOG10
- MOD
- MROUND
- MULTINOMIAL
- ODD
- PI
- POLYNOMIAL
- POWER
- PRODUCT
- QUOTIENT
- RAND
- RANDBETWEEN
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- SERIESSUM
- SIGN
- SQRT
- SQRTPI
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SUMSQ
- SUMX2MY2
- SUMX2PY2
- SUMXMY2
- TRUNC
- ADDRESS
- AREAS
- CHOOSE
- COLUMN
- COLUMNS
- FORMULATEXT
- HLOOKUP
- HYPERLINK
- INDEX
- INDIRECT
- INTERSECT.RANGES
- LOOKUP
- MATCH
- OFFSET
- REFERENCE.NAME
- ROW
- ROWS
- TRANSPOSE
- UNION.RANGES
- VLOOKUP
- XLOOKUP
- XMATCH
- 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
- CHAR
- CLEAN
- CODE
- CONCATENATE
- COUNTMATCHES
- DOLLAR
- EXACT
- FIND
- FIXED
- LEFT
- LEN
- LOWER
- MID
- PLAINTEXT
- PROPER
- REGEX
- REGEX.EXTRACT
- REPLACE
- REPT
- RIGHT
- SEARCH
- SUBSTITUTE
- T
- TEXTAFTER
- TEXTBEFORE
- TEXTBETWEEN
- TRIM
- UPPER
- VALUE
- ACOS
- ACOSH
- ASIN
- ASINH
- ATAN
- ATAN2
- ATANH
- COS
- COSH
- DEGREES
- RADIANS
- SIN
- SINH
- TAN
- TANH

QUOTIENT

The QUOTIENT function returns the integer quotient of two numbers. Both arguments are number values.

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 zero will result and the function will return 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.

See alsoMOD

Helpful?