Operations
Spreadsheet functions for operations — conformant with Google Sheets and Excel.
Functions commonly used in operations:
- ADDRESS
- AND
- ARABIC
- ARRAYFORMULA
- ARRAY_CONSTRAIN
- ASC
- AVEDEV
- AVERAGE.WEIGHTED
- AVERAGEA
- AVERAGEIF
- AVERAGEIFS
- BASE
- BETA.DIST
- BETA.INV
- BETADIST
- BETAINV
- BINOM.DIST
- BINOM.INV
- BINOMDIST
- BYCOL
- BYROW
- CEILING
- CEILING.MATH
- CEILING.PRECISE
- CELL
- CHAR
- CHIDIST
- CHIINV
- CHISQ.DIST
- CHISQ.DIST.RT
- CHISQ.INV
- CHISQ.INV.RT
- CHISQ.TEST
- CHITEST
- CHOOSE
- CHOOSECOLS
- CHOOSEROWS
- CLEAN
- CODE
- COLUMN
- COLUMNS
- CONCATENATE
- CONFIDENCE
- CONFIDENCE.NORM
- CONFIDENCE.T
- CONVERT
- COUNT
- COUNTA
- COUNTBLANK
- COUNTIF
- COUNTIFS
- COUNTUNIQUE
- CRITBINOM
- DATE
- DATEDIF
- DATEVALUE
- DAVERAGE
- DAY
- DAYS
- DCOUNT
- DCOUNTA
- DECIMAL
- DEVSQ
- DGET
- DMAX
- DMIN
- DPRODUCT
- DSTDEV
- DSTDEVP
- DSUM
- DVAR
- DVARP
- ENCODEURL
- EOMONTH
- EPOCHTODATE
- ERROR.TYPE
- EVEN
- EXACT
- EXPON.DIST
- EXPONDIST
- F.DIST
- F.DIST.RT
- F.INV
- F.INV.RT
- F.TEST
- FALSE
- FDIST
- FILTER
- FIND
- FINDB
- FINV
- FISHER
- FISHERINV
- FIXED
- FLATTEN
- FLOOR
- FORECAST
- FORECAST.LINEAR
- FORMULATEXT
- FREQUENCY
- FTEST
- GAUSS
- GCD
- GROWTH
- HARMEAN
- HLOOKUP
- HOUR
- HSTACK
- HYPERLINK
- HYPGEOM.DIST
- HYPGEOMDIST
- IF
- IFERROR
- IFNA
- IFS
- INDEX
- INDIRECT
- INT
- INTERCEPT
- ISBETWEEN
- ISBLANK
- ISDATE
- ISEMAIL
- ISERR
- ISERROR
- ISEVEN
- ISFORMULA
- ISLOGICAL
- ISNA
- ISNONTEXT
- ISNUMBER
- ISODD
- ISOWEEKNUM
- ISREF
- ISTEXT
- ISURL
- ISZONED
- JOIN
- LARGE
- LCM
- LEFT
- LEFTB
- LEN
- LENB
- LET
- LINEST
- LOGEST
- LOOKUP
- LOWER
- MAKEARRAY
- MAP
- MARGINOFERROR
- MATCH
- MAX
- MAXA
- MAXIFS
- MEDIAN
- MID
- MIDB
- MIN
- MINA
- MINIFS
- MINUTE
- MOD
- MODE
- MODE.MULT
- MODE.SNGL
- MONTH
- MROUND
- N
- NA
- NEGBINOM.DIST
- NEGBINOMDIST
- NETWORKDAYS
- NETWORKDAYS.INTL
- NORM.DIST
- NORMDIST
- NOT
- NOW
- ODD
- OFFSET
- OR
- PEARSON
- PERCENTILE
- PERCENTILE.EXC
- PERCENTILE.INC
- PERCENTRANK
- PERMUT
- PERMUTATIONA
- POISSON
- POISSON.DIST
- PROB
- PRODUCT
- PROPER
- QUARTILE.EXC
- QUOTIENT
- RANK
- REDUCE
- REGEXEXTRACT
- REGEXMATCH
- REGEXREPLACE
- REPLACE
- REPLACEB
- REPT
- RIGHT
- RIGHTB
- ROMAN
- ROUND
- ROUNDDOWN
- ROUNDUP
- ROW
- ROWS
- RSQ
- SCAN
- SEARCH
- SEARCHB
- SECOND
- SHEET
- SHEETS
- SIGN
- SKEW.P
- SMALL
- SORT
- SORTBY
- SORTN
- SPLIT
- STDEV
- STDEV.P
- STDEV.S
- STDEVA
- STDEVP
- STDEVPA
- STEYX
- SUBSTITUTE
- SUBTOTAL
- SUM
- SUMIF
- SUMIFS
- SUMPRODUCT
- SWITCH
- T
- T.DIST
- T.DIST.2T
- T.DIST.RT
- T.INV
- T.INV.2T
- TDIST
- TEXT
- TEXTJOIN
- TIME
- TIMEVALUE
- TINV
- TOCOL
- TODAY
- TOROW
- TO_DATE
- TO_PERCENT
- TO_PURE_NUMBER
- TO_TEXT
- TRANSPOSE
- TREND
- TRIM
- TRIMMEAN
- TRUE
- TRUNC
- TYPE
- TZABBR
- TZADD
- TZBOARD
- TZCOMPARETEXT
- TZCONVERT
- TZDATETIME
- TZDIFF
- TZFROMEPOCH
- TZINWINDOW
- TZISDST
- TZLOCALIZE
- TZLOCALSTATUS
- TZNOW
- TZOFFSETDIFF
- TZOVERLAP
- TZPARSE
- TZPART
- TZSERIAL
- TZSTRING
- TZTABLE
- TZTEXT
- TZVALID
- TZWORLDCLOCK
- UNICHAR
- UNICODE
- UNIQUE
- UPPER
- VALUE
- VAR
- VAR.P
- VAR.S
- VARA
- VARP
- VARPA
- VSTACK
- WEEKDAY
- WEEKNUM
- WEIBULL
- WEIBULL.DIST
- WORKDAY
- WORKDAY.INTL
- WRAPCOLS
- WRAPROWS
- XLOOKUP
- XMATCH
- XOR
- YEAR
- Z.TEST
- ZTEST