Microsoft Excel Functions

Add-in and Automation Functions

Compatibility Functions

BETADIST
BETAINV
BINOMDIST
CEILING
CHIDIST
CHIINV
CHITEST
CONFIDENCE
COVAR
CRITBINOM
EXPONDIST
FDIST
FINV
FLOOR
FTEST
GAMMADIST
GAMMAINV
HYPGEOMDIST
LOGINV
LOGNORMDIST
MODE
NEGBINOMDIST
NORM.INV (Excel 2010 onwards only)
NORMDIST
NORMSDIST
NORMSINV
PERCENTILE
PERCENTRANK
POISSON
QUARTILE
RANK
STDEV
STDEVP
TDIST
TINV
TTEST
VAR
VARP
WEIBULL
ZTEST

Cube Functions

CUBEKPIMEMBER
CUBEMEMBER
CUBEMEMBERPROPERTY
CUBERANKEDMEMBER
CUBESET
CUBESETCOUNT
CUBEVALUE

Database Functions

DAVERAGE
DCOUNT
DCOUNTA
DGET
DMAX
DMIN
DPRODUCT
DSTDEV
DSTDEVP
DSUM
DVAR
DVARP

Date and Time Functions

DATE
DATEDIF
DATEVALUE
DAY
DAYS (Excel 2013 onwards only)
DAYS360
EDATE
EOMONTH
HOUR
ISOWEEKNUM (Excel 2013 onwards only)
MINUTE
MONTH
NETWORKDAYS
NETWORKDAYS.INTL (Excel 2010 onwards only)
NOW
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WEEKNUM
WORKDAY
WORKDAY.INTL (Excel 2010 onwards only)
YEAR
YEARFRAC

Engineering Functions

BESSELI
BESSELJ
BESSELK
BESSELY
BIN2DEC
BIN2HEX
BIN2OCT
BITAND (Excel 2013 onwards only)
BITLSHIFT (Excel 2013 onwards only)
BITOR (Excel 2013 onwards only)
BITRSHIFT (Excel 2013 onwards only)
BITXOR (Excel 2013 onwards only)
COMPLEX
CONVERT
DEC2BIN
DEC2HEX
DEC2OCT
DELTA
ERF
ERF.PRECISE (Excel 2010 onwards only)
ERFC
ERFC.PRECISE (Excel 2010 onwards only)
GESTEP
HEX2BIN
HEX2DEC
HEX2OCT
IMABS
IMAGINARY
IMARGUMENT
IMCONJUGATE
IMCOS
IMCOSH (Excel 2013 onwards only)
IMCOT (Excel 2013 onwards only)
IMCSC (Excel 2013 onwards only)
IMCSCH (Excel 2013 onwards only)
IMDIV
IMEXP
IMLN
IMLOG10
IMLOG2
IMPOWER
IMPRODUCT
IMREAL
IMSEC (Excel 2013 onwards only)
IMSECH (Excel 2013 onwards only)
IMSIN
IMSINH (Excel 2013 onwards only)
IMSQRT
IMSUB
IMSUM
IMTAN (Excel 2013 onwards only)
OCT2BIN
OCT2DEC
OCT2HEX

Financial Functions

ACCRINT
ACCRINTM
AMORDEGRC
AMORLINC
COUPDAYBS
COUPDAYS
COUPDAYSNC
COUPNCD
COUPNUM
COUPPCD
CUMIPMT
CUMPRINC
DB
DDB
DISC
DOLLARDE
DOLLARFR
DURATION
EFFECT
FV
FVSCHEDULE
INTRATE
IPMT
IRR
ISPMT
MDURATION
MIRR
NOMINAL
NPER
NPV
ODDFPRICE
ODDFYIELD
ODDLPRICE
ODDLYIELD
PDURATION (Excel 2013 onwards only)
PMT
PPMT
PRICE
PRICEDISC
PRICEMAT
PV
RATE
RECEIVED
RRI (Excel 2013 onwards only)
SLN
STOCKHISTORY
SYD
TBILLEQ
TBILLPRICE
TBILLYIELD
VDB
XIRR
XNPV
YIELD
YIELDDISC
YIELDMAT

Information Functions

CELL
ERROR.TYPE
INFO
ISBLANK
ISERR
ISERROR
ISEVEN
ISFORMULA (Excel 2013 onwards only)
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISOMITTED (Microsoft 365 only)
ISREF
ISTEXT
N
NA
SHEET (Excel 2013 onwards only)
SHEETS (Excel 2013 onwards only)
TYPE

Logical Functions

AND
BYCOL (Microsoft 365 only)
BYROW (Microsoft 365 only)
IF
IFERROR
IFNA (Excel 2013 onwards only)
IFS (2019 onwards only)
LAMBDA (Microsoft 365 only)
LET (Microsoft 365 only)
MAKEARRAY (Microsoft 365 only)
MAP (Microsoft 365 only)
NOT
OR
REDUCE (Microsoft 365 only)
SCAN (Microsoft 365 only)
SWITCH (Microsoft 365 only)
XOR (Excel 2013 onwards only)
FALSE
TRUE

Lookup and Reference Functions

ADDRESS
AREAS
CHOOSE
CHOOSECOLS (Microsoft 365 only)
CHOOSEROWS (Microsoft 365 only)
COLUMN
COLUMNS
DROP (Microsoft 365 only)
EXPAND (Microsoft 365 only)
FILTER (Microsoft 365 only)
FORMULATEXT (Excel 2013 onwards only)
GETPIVOTDATA
HLOOKUP
HSTACK (Microsoft 365 only)
HYPERLINK
INDEX
INDIRECT
LOOKUP
MATCH
OFFSET
ROW
ROWS
RTD
SORT (Microsoft 365 only)
SORTBY (Microsoft 365 only)
TAKE (Microsoft 365 only)
TOCOL (Microsoft 365 only)
TOROW (Microsoft 365 only)
TRANSPOSE
UNIQUE (Microsoft 365 only)
VLOOKUP
VSTACK (Microsoft 365 only)
WRAPCOLS (Microsoft 365 only)
WRAPROWS (Microsoft 365 only)
XLOOKUP (Microsoft 365 only)
XMATCH (Microsoft 365 only)

Math and Trigonometry Functions

ABS
ACOS
ACOSH
ACOT (Excel 2013 onwards only)
ACOTH (Excel 2013 onwards only)
AGGREGATE
ARABIC (Excel 2013 onwards only)
ASIN
ASINH
ATAN
ATAN2
ATANH
BASE
CEILING.MATH (Excel 2013 onwards only)
CEILING.PRECISE
COMBIN
COMBINA (Excel 2013 onwards only)
COS
COSH
COT (Excel 2013 onwards only)
COTH (Excel 2013 onwards only)
CSC (Excel 2013 onwards only)
CSCH (Excel 2013 onwards only)
DECIMAL (Excel 2013 onwards only)
DEGREES
EVEN
EXP
FACT
FACTDOUBLE
FLOOR.MATH (Excel 2013 onwards only)
FLOOR.PRECISE
GCD
INT
ISO.CEILING (Excel 2013 onwards only)
LCM
LN
LOG
LOG10
MDETERM
MINVERSE
MMULT
MOD
MROUND
MULTINOMIAL
MUNIT (Excel 2013 onwards only)
ODD
PI
POWER
PRODUCT
QUOTIENT
RADIANS
RAND
RANDARRAY (Microsoft 365 only)
RANDBETWEEN
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SEC (Excel 2013 onwards only)
SECH (Excel 2013 onwards only)
SEQUENCE (Microsoft 365 only)
SERIESSUM
SIGN
SIN
SINH
SQRT
SQRTPI
SUBTOTAL
SUM
SUMIF
SUMIFS
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
TAN
TANH
TRUNC

Statistical Functions

AVEDEV
AVERAGE
AVERAGEA
AVERAGEIF
AVERAGEIFS
BETA.DIST (Excel 2010 onwards only)
BETA.INV (Excel 2010 onwards only)
BINOM.DIST (Excel 2010 onwards only)
BINOM.DIST.RANGE (Excel 2013 onwards only)
BINOM.INV (Excel 2010 onwards only)
CHISQ.DIST (Excel 2010 onwards only)
CHISQ.DIST.RT (Excel 2010 onwards only)
CHISQ.INV (Excel 2010 onwards only)
CHISQ.INV.RT (Excel 2010 onwards only)
CHISQ.TEST (Excel 2010 onwards only)
CONFIDENCE.NORM (Excel 2010 onwards only)
CONFIDENCE.T (Excel 2010 onwards only)
CORREL
COUNT
COUNTA
COUNTBLANK
COUNTIF
COUNTIFS
COVARIANCE.P (Excel 2010 onwards only)
COVARIANCE.S (Excel 2010 onwards only)
DEVSQ
EXPON.DIST (Excel 2010 onwards only)
F.DIST (Excel 2010 onwards only)
F.DIST.RT (Excel 2010 onwards only)
F.INV (Excel 2010 onwards only)
F.INV.RT (Excel 2010 onwards only)
F.TEST (Excel 2010 onwards only)
FISHER
FISHERINV
FORECAST
FORECAST.ETS (Excel 2016 onwards only)
FORECAST.ETS.CONFINT (Excel 2016 onwards only)
FORECAST.ETS.SEASONALITY (Excel 2016 onwards only)
FORECAST.ETS.STAT (Excel 2016 onwards only)
FORECAST.LINEAR (Excel 2016 onwards only)
FREQUENCY
GAMMA (Excel 2013 onwards only)
GAMMA.DIST (Excel 2010 onwards only)
GAMMA.INV (Excel 2010 onwards only)
GAMMALN
GAMMALN.PRECISE (Excel 2010 onwards only)
GAUSS (Excel 2013 onwards only)
GEOMEAN
GROWTH
HARMEAN
HYPGEOM.DIST
INTERCEPT
KURT
LARGE
LINEST
LOGEST
LOGNORM.DIST (Excel 2010 onwards only)
LOGNORM.INV (Excel 2010 onwards only)
MAX
MAXA
MAXIFS (2019 onwards only)
MEDIAN
MIN
MINA
MINIFS (2019 onwards only)
MODE.MULT (Excel 2010 onwards only)
MODE.SNGL (Excel 2010 onwards only)
NEGBINOM.DIST (Excel 2010 onwards only)
NORM.DIST (Excel 2010 onwards only)
NORM.S.DIST (Excel 2010 onwards only)
NORM.S.INV (Excel 2010 onwards only)
NORMINV
PEARSON
PERCENTILE.EXC (Excel 2010 onwards only)
PERCENTILE.INC (Excel 2010 onwards only)
PERCENTRANK.EXC (Excel 2010 onwards only)
PERCENTRANK.INC (Excel 2010 onwards only)
PERMUT
PERMUTATIONA (Excel 2013 onwards only)
PHI (Excel 2013 onwards only)
POISSON.DIST (Excel 2010 onwards only)
PROB
QUARTILE.EXC (Excel 2010 onwards only)
QUARTILE.INC (Excel 2010 onwards only)
RANK.AVG (Excel 2010 onwards only)
RANK.EQ (Excel 2010 onwards only)
RSQ
SKEW
SKEW.P (Excel 2013 onwards only)
SLOPE
SMALL
STANDARDIZE
STDEV.P (Excel 2010 onwards only)
STDEV.S (Excel 2010 onwards only)
STDEVA
STDEVPA
STEYX
T.DIST (Excel 2010 onwards only)
T.DIST.2T (Excel 2010 onwards only)
T.DIST.RT (Excel 2010 onwards only)
T.INV (Excel 2010 onwards only)
T.INV.2T (Excel 2010 onwards only)
T.TEST (Excel 2010 onwards only)
TREND
TRIMMEAN
VAR.P (Excel 2010 onwards only)
VAR.S (Excel 2010 onwards only)
VARA
VARPA
WEIBULL.DIST (Excel 2010 onwards only)
Z.TEST (Excel 2010 onwards only)

Text Functions

ARRAYTOTEXT (Microsoft 365 only)
ASC
BAHTTEXT
CHAR
CLEAN
CODE
CONCAT (2019 onwards only)
CONCATENATE
DBCS (Excel 2013 onwards only)
DOLLAR
EXACT
FIND
FINDB
FIXED
JIS
LEFT
LEFTB
LEN
LENB
LOWER
MID
MIDB
NUMBERVALUE (Excel 2013 onwards only)
PHONETIC
PROPER
REPLACE
REPLACEB
REPT
RIGHT
RIGHTB
SEARCH
SEARCHB
SUBSTITUTE
T
TEXT
TEXTAFTER (Microsoft 365 only)
TEXTBEFORE (Microsoft 365 only)
TEXTJOIN (Microsoft 365 only)
TEXTSPLIT (Microsoft 365 only)
TRIM
UNICHAR (Excel 2013 onwards only)
UNICODE (Excel 2013 onwards only)
UPPER
VALUE
VALUETOTEXT (Microsoft 365 only)

Web Functions

ENCODEURL (Excel 2013 onwards only)
FILTERXML (Excel 2013 onwards only)
WEBSERVICE (Excel 2013 onwards only)