Excel functions
Compatibility
BETADIST function
BETAINV function
BINOMDIST
CHIDIST function
CHIINV function
CHITEST function
CONFIDENCE
COVAR function
CRITBINOM
EXPONDIST
FDIST function
FLOOR function
FORECAST function
FTEST function
GAMMADIST
LOGNORMDIST
MODE function
PERCENTRANK
QUARTILE function
RANK function
STDEV function
Database
DAVERAGE function
DCOUNT function
DCOUNTA function
DGET function
DMAX function
DMIN function
DPRODUCT function
DSTDEV function
DSTDEVP function
DSUM function
DVARP function
Date and Time
DATE function
DATEDIF function
DATEVALUE
DAY function
DAYS function [2013]
EDATE function
EOMONTH function
HOUR function
MINUTE function
MONTH function
NETWORKDAYS
NETWORKDAYS.INTL [2010]
NOW function
SECOND function
TIME function
TIMEVALUE
TODAY function
WEEKDAY function
WEEKNUM function
WORKDAY function
YEAR function
YEARFRAC function
Engineering
BIN2DEC function
BIN2HEX function
BIN2OCT function
BITAND function [2013]
BITLSHIFT [2013]
BITOR function [2013]
BITRSHIFT [2013]
BITXOR function [2013]
COMPLEX function
CONVERT function
DEC2BIN function
DEC2HEX function
DEC2OCT function
DELTA function
Financial
ACCRINT function
ACCRINTM function
AMORDEGRC
AMORLINC function
CUMIPMT function
CUMPRINC function
DB function
DDB function
DOLLARFR function
EFFECT function
FV function
IPMT function
ISPMT function
NOMINAL function
PDURATION
PMT function
PPMT function
PRICEMAT function
RATE function
RRI function
SYD function
TBILLPRICE
TBILLYIELD
VDB function
XNPV function
YIELD function
Information
CELL function
ERROR.TYPE
INFO function
ISBLANK function
ISERR function
ISERROR function
ISFORMULA [2013]
ISLOGICAL
ISNA function
ISNONTEXT
ISNUMBER function
ISODD function
ISREF function
ISTEXT function
N function
NA function
SHEET function
SHEETS function
TYPE function
Logical
AND function
FALSE function
IF function
IFERROR function [2007]
IFNA function [2013]
IFS function [Office 365]
NOT function
OR function
SWITCH function [2016]
TRUE function
XOR function [2013]
Lookup and reference
ADDRESS function
AREAS function
CHOOSE function
COLUMN function
COLUMNS function
FORMULATEXT [2013]
HLOOKUP function
HYPERLINK
INDEX function
INDIRECT function
LOOKUP function
MATCH function
OFFSET function
ROW function
ROWS function
TRANSPOSE
VLOOKUP function
Math and trigonometry
ABS function
ACOS function
ACOSH function
ACOT function [2013]
ACOTH function [2013]
AGGREGATE
ASIN function
ASINH function
ATAN function
ATAN2 function
ATANH function
BASE function
CEILING function
COMBIN function
COMBINA function [2013]
COS function
COSH function
COT function [2013]
COTH function [2013]
CSC function
DECIMAL function [2013]
DEGREES function
EVEN function
EXP function
FACT function
FACTDOUBLE
FLOOR.MATH [2013]
FLOOR.PRECISE [2010]
GCD function
INT function
LCM function
LN function
LOG function
LOG10 function
MINVERSE function
MMULT function
MOD function
MROUND function
MULTINOMIAL
MUNIT function [2013]
PI function
POWER function
PRODUCT function
QUOTIENT function
RADIANS function
RAND function
RANDBETWEEN
ROUNDDOWN
ROUNDUP function
SEC function
SECH function
SERIESSUM
SIGN function
SIN function
SINH function
SQRT function
SUBTOTAL function
SUM function
SUMIF function
SUMIFS function [2007]
SUMPRODUCT
SUMSQ function
SUMX2MY2 function
SUMX2PY2 function
SUMXMY2 function
TAN function
TANH function
TRUNC function
Statistical
AVEDEV function
AVERAGE function
AVERAGEA function
AVERAGEIF [2007]
AVERAGEIFS [2007]
BETA.DIST [2010]
BETA.INV function [2010]
BINOM.DIST [2010]
BINOM.INV [2010]
CHISQ.DIST
CHISQ.DIST.RT [2010]
CHISQ.INV [2010]
CHISQ.INV.RT [2010]
CHISQ.TEST [2010]
CONFIDENCE.NORM [2010]
CONFIDENCE.T [2010]
CORREL function
COUNT function
COUNTA function
COUNTBLANK
COUNTIF function
COUNTIFS function [2007]
COVARIANCE.P [2010]
COVARIANCE.S [2010]
EXPON.DIST [2010]
F.DIST function [2010]
F.DIST.RT [2010]
F.TEST function [2010]
FORECAST.LINEAR [2016]
FREQUENCY
GAMMA function [2013]
GAMMA.DIST [2010]
GEOMEAN function
GROWTH function
INTERCEPT
LARGE function
LINEST function
LOGEST function
LOGNORM.DIST [2010]
MAX function
MAXIFS function [2016]
MEDIAN function
MIN function
MINA function
MINIFS function [2016]
MODE.MULT [2010]
MODE.SNGL [2010]
NORM.DIST [2010]
NORM.INV function [2010]
PERCENTRANK.EXC [2010]
PERCENTRANK.INC [2010]
PERMUT function
PERMUTATIONA
PHI function
PROB function
QUARTILE.EXC [2010]
QUARTILE.INC [2010]
RANK.AVG function [2010]
RANK.EQ function [2010]
SKEW function
SLOPE function
SMALL function
STANDARDIZE
STDEV.P function [2010]
STDEV.S function [2010]
STDEVA function
STDEVPA function
TREND function
TRIMMEAN function
VAR.P function [2010]
VAR.S function [2010]
Text
ASC function
CHAR function
CLEAN function
CODE function
CONCAT function [Office 365]
CONCATENATE
EXACT function
FIND function
FIXED function
LEFT function
LEN function
LOWER function
MID function
REPT function
RIGHT function
SEARCH function
SUBSTITUTE
T function
TEXT function
TEXTJOIN function [Office 365]
TRIM function
UNICHAR function [2013]
UNICODE function [2013]
UPPER function
VALUE function
Web
ENCODEURL [2013]
WEBSERVICE [2013]
