Documentation/Calc Functions/List of Functions
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
Mathematical functions
ABS
ACOS
ACOSH
ACOT
ACOTH
AGGREGATE
ASIN
ASINH
ATAN
ATAN2
ATANH
BITAND
BITLSHIFT
BITOR
BITRSHIFT
BITXOR
CEILING
CEILING.MATH
CEILING.PRECISE
CEILING.XCL
COLOR
COMBIN
COMBINA
CONVERT_OOO
COS
COSH
COT
COTH
CSC
CSCH
DEGREES
EUROCONVERT
EVEN
EXP
FACT
FLOOR
FLOOR.MATH
FLOOR.PRECISE
FLOOR.XCL
GCD
GCD_EXCEL2003
INT
ISO.CEILING
LCM
LCM_EXCEL2003
LN
LOG
LOG10
MOD
MROUND
MULTINOMIAL
ODD
PI
POWER
PRODUCT
QUOTIENT
RADIANS
RAND
RAND.NV
RANDBETWEEN
RANDBETWEEN.NV
RAWSUBTRACT
ROUND
ROUNDDOWN
ROUNDSIG
ROUNDUP
SEC
SECH
SERIESSUM
SIGN
SIN
SINH
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMSQ
TAN
TANH
TRUNC
Financial analysis functions
ACCRINT
ACCRINTM
AMORDEGRC
AMORLINC
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
CUMIPMT
CUMIPMT_ADD
CUMPRINC
CUMPRINC_ADD
DB
DDB
DISC
DOLLARDE
DOLLARFR
DURATION
EFFECT
EFFECT_ADD
FV
FVSCHEDULE
INTRATE
IPMT
IRR
ISPMT
MDURATION
MIRR
NOMINAL
NOMINAL_ADD
NPER
NPV
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
OPT_BARRIER
OPT_PROB_HIT
OPT_PROB_INMONEY
OPT_TOUCH
PDURATION
PMT
PPMT
PRICE
PRICEDISC
PRICEMAT
PV
RATE
RECEIVED
RRI
SLN
SYD
TBILLEQ
TBILLPRICE
TBILLYIELD
VDB
XIRR
XNPV
YIELD
YIELDDISC
YIELDMAT
Statistical analysis functions
AVEDEV
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
B
BETA.DIST
BETA.INV
BETADIST
BETAINV
BINOM.DIST
BINOM.INV
BINOMDIST
CHIDIST
CHIINV
CHISQ.DIST
CHISQ.DIST.RT
CHISQ.INV
CHISQ.INV.RT
CHISQ.TEST
CHISQDIST
CHISQINV
CHITEST
CONFIDENCE
CONFIDENCE.NORM
CONFIDENCE.T
CORREL
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
COVAR
COVARIANCE.P
COVARIANCE.S
CRITBINOM
DEVSQ
ERF.PRECISE
ERFC.PRECISE
EXPON.DIST
EXPONDIST
F.DIST
F.DIST.RT
F.INV
F.INV.RT
F.TEST
FDIST
FINV
FISHER
FISHERINV
FORECAST
FORECAST.ETS.ADD
FORECAST.ETS.MULT
FORECAST.ETS.PI.ADD
FORECAST.ETS.PI.MULT
FORECAST.ETS.SEASONALITY
FORECAST.ETS.STAT.ADD
FORECAST.ETS.STAT.MULT
FORECAST.LINEAR
FTEST
GAMMA
GAMMA.DIST
GAMMA.INV
GAMMADIST
GAMMAINV
GAMMALN
GAMMALN.PRECISE
GAUSS
GEOMEAN
HARMEAN
HYPGEOM.DIST
HYPGEOMDIST
INTERCEPT
KURT
LARGE
LOGINV
LOGNORM.DIST
LOGNORM.INV
LOGNORMDIST
MAX
MAXA
MAXIFS
MEDIAN
MIN
MINA
MINIFS
MODE
MODE.MULT
MODE.SNGL
NEGBINOM.DIST
NEGBINOMDIST
NORM.DIST
NORM.INV
NORM.S.DIST
NORM.S.INV
NORMDIST
NORMINV
NORMSDIST
NORMSINV
PEARSON
PERCENTILE
PERCENTILE.EXC
PERCENTILE.INC
PERCENTRANK
PERCENTRANK.EXC
PERCENTRANK.INC
PERMUT
PERMUTATIONA
PHI
POISSON
POISSON.DIST
PROB
QUARTILE
QUARTILE.EXC
QUARTILE.INC
RANK
RANK.AVG
RANK.EQ
RSQ
SKEW
SKEWP
SLOPE
SMALL
STANDARDIZE
STDEV
STDEV.P
STDEV.S
STDEVA
STDEVP
STDEVPA
STEYX
T.DIST
T.DIST.2T
T.DIST.RT
T.INV
T.INV.2T
T.TEST
TDIST
TINV
TRIMMEAN
TTEST
VAR
VAR.P
VAR.S
VARA
VARP
VARPA
WEIBULL
WEIBULL.DIST
Z.TEST
ZTEST
Date and time functions
DATE
DATEDIF
DATEVALUE
DAY
DAYS
DAYS360
DAYSINMONTH
DAYSINYEAR
EASTERSUNDAY
EDATE
EOMONTH
HOUR
ISLEAPYEAR
ISOWEEKNUM
MINUTE
MONTH
MONTHS
NETWORKDAYS
NETWORKDAYS.INTL
NETWORKDAYS_EXCEL2003
NOW
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WEEKNUM
WEEKNUM_EXCEL2003
WEEKS
WEEKSINYEAR
WORKDAY
WORKDAY.INTL
YEAR
YEARFRAC
YEARS
Logical functions
Information functions
CELL
CURRENT
FORMULA
INFO
ISBLANK
ISERR
ISERROR
ISEVEN
ISEVEN_ADD
ISFORMULA
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISODD_ADD
ISREF
ISTEXT
N
NA
TYPE
Database functions
Array functions
FOURIER
FREQUENCY
GROWTH
LINEST
LOGEST
MDETERM
MINVERSE
MMULT
MUNIT
SUMPRODUCT
SUMX2MY2
SUMX2PY2
SUMXMY2
TRANSPOSE
TREND
Spreadsheet functions
ADDRESS
AREAS
CHOOSE
COLUMN
COLUMNS
DDE
ERROR.TYPE
ERRORTYPE
GETPIVOTDATA
HLOOKUP
HYPERLINK
INDEX
INDIRECT
LOOKUP
MATCH
OFFSET
ROW
ROWS
SHEET
SHEETS
STYLE
VLOOKUP
Text functions
ARABIC
ASC
BAHTTEXT
BASE
CHAR
CLEAN
CODE
CONCAT
CONCATENATE
DECIMAL
DOLLAR
ENCODEURL
EXACT
FILTERXML
FIND
FINDB
FIXED
JIS
LEFT
LEFTB
LEN
LENB
LOWER
MID
MIDB
NUMBERVALUE
PROPER
REGEX
REPLACE
REPLACEB
REPT
RIGHT
RIGHTB
ROMAN
ROT13
SEARCH
SEARCHB
SUBSTITUTE
T
TEXT
TEXTJOIN
TRIM
UNICHAR
UNICODE
UPPER
VALUE
WEBSERVICE
Add-in functions
BESSELI
BESSELJ
BESSELK
BESSELY
BIN2DEC
BIN2HEX
BIN2OCT
COMPLEX
CONVERT
DEC2BIN
DEC2HEX
DEC2OCT
DELTA
ERF
ERFC
FACTDOUBLE
GESTEP
HEX2BIN
HEX2DEC
HEX2OCT
IMABS
IMAGINARY
IMARGUMENT
IMCONJUGATE
IMCOS
IMCOSH
IMCOT
IMCSC
IMCSCH
IMDIV
IMEXP
IMLN
IMLOG10
IMLOG2
IMPOWER
IMPRODUCT
IMREAL
IMSEC
IMSECH
IMSIN
IMSINH
IMSQRT
IMSUB
IMSUM
IMTAN
OCT2BIN
OCT2DEC
OCT2HEX