Functions alphabetically | Functions by category

Click on a link below to quickly navigate to category.

Function Categories
Compatibility Financial Math and trigonometry
Database Information Statistical
Date and Time Logical Text
Engineering Lookup and reference Web
Compatibility
BETADIST functionCOVAR functionGAMMADIST function
BETAINV functionCRITBINOM functionLOGNORMDIST function
BINOMDIST functionEXPONDIST functionMODE function
CHIDIST functionFDIST functionPERCENTRANK function
CHIINV functionFLOOR functionQUARTILE function
CHITEST functionFORECAST functionRANK function
CONFIDENCE functionFTEST functionSTDEV function

Back to top
Database
DAVERAGE functionDMAX functionDSTDEVP function
DCOUNT functionDMIN functionDSUM function
DCOUNTA functionDPRODUCT functionDVARP function
DGET functionDSTDEV function

Back to top
Date and time
DATE functionMINUTE functionTODAY function
DATEDIF functionMONTH functionWEEKDAY function
DATEVALUE functionNETWORKDAYS functionWEEKNUM function
DAY functionNETWORKDAYS.INTL functionWORKDAY function
DAYS functionNOW functionYEAR function
EDATE functionSECOND functionYEARFRAC function
EOMONTH functionTIME function
HOUR functionTIMEVALUE function

Back to top
Engineering
BIN2DEC functionBITOR functionDEC2BIN function
BIN2HEX functionBITRSHIFT functionDEC2HEX function
BIN2OCT functionBITXOR functionDEC2OCT function
BITAND functionCOMPLEX functionDELTA function
BITLSHIFT functionCONVERT function

Back to top
Financial
ACCRINT functionEFFECT functionRATE function
ACCRINTM functionFV functionRRI function
AMORDEGRC functionIPMT functionSYD function
AMORLINC functionISPMT functionTBILLPRICE function
CUMIPMT functionNOMINAL functionTBILLYIELD function
CUMPRINC functionPDURATION functionVDB function
DB functionPMT functionXNPV function
DDB functionPPMT functionYIELD function
DOLLARFR functionPRICEMAT function

Back to top
Information
CELL functionISLOGICAL functionN function
ERROR.TYPE functionISNA functionNA function
INFO functionISNONTEXT functionSHEET function
ISBLANK functionISNUMBER functionSHEETS function
ISERR functionISODD functionTYPE function
ISERROR functionISREF function
ISFORMULA functionISTEXT function

Back to top
Logical
AND functionIFNA functionSWITCH function
FALSE functionIFS functionTRUE function
IF functionNOT functionXOR function
IFERROR functionOR function

Back to top
Lookup and reference
ADDRESS functionHLOOKUP functionROW function
AREAS functionHYPERLINK functionROWS function
CHOOSE functionINDEX functionSORT function
COLUMN functionINDIRECT functionSORTBY function
COLUMNS functionLOOKUP functionTRANSPOSE function
FILTER functionMATCH functionUNIQUE function
FORMULATEXT functionOFFSET functionVLOOKUP function

Back to top
Math and trigonometry
ABS functionFACT functionROUNDUP function
ACOS functionFACTDOUBLE functionSEC function
ACOSH functionFLOOR.MATH functionSECH function
ACOT functionFLOOR.PRECISE functionSEQUENCE function
ACOTH functionGCD functionSERIESSUM function
AGGREGATE functionINT functionSIGN function
ASIN functionLCM functionSIN function
ASINH functionLN functionSINH function
ATAN functionLOG functionSQRT function
ATAN2 functionLOG10 functionSUM function
ATANH functionMINVERSE functionSUMIF function
BASE functionMMULT functionSUMIFS function
CEILING functionMOD functionSUMPRODUCT function
COMBIN functionMROUND functionSUMSQ function
COMBINA functionMULTINOMIAL functionSUMX2MY2 function
COS functionMUNIT functionSUMX2PY2 function
COSH functionPI functionSUMXMY2 function
COT functionPOWER functionTAN function
COTH functionPRODUCT functionTANH function
CSC functionRADIANS functionTRUNC function
DECIMAL functionRAND functionSUBTOTAL function
DEGREES functionRANDARRAY functionQUOTIENT function
EVEN functionRANDBETWEEN function
EXP functionROUNDDOWN function

Back to top
Statistical
AVEDEV functionEXPON.DIST functionNORM.INV function
AVERAGE functionF.DIST functionPERCENTRANK.EXC function
AVERAGEA functionF.DIST.RT functionPERCENTRANK.INC function
AVERAGEIF functionF.TEST functionPERMUT function
AVERAGEIFS functionFORECAST.LINEAR functionPERMUTATIONA function
BETA.DIST functionFREQUENCY functionPHI function
BETA.INV functionGAMMA functionPROB function
BINOM.DIST functionGAMMA.DIST functionQUARTILE.EXC function
BINOM.INV functionGEOMEAN functionQUARTILE.INC function
CHISQ.DIST functionGROWTH functionRANK.AVG function
CHISQ.DIST.RT functionINTERCEPT functionRANK.EQ function
CHISQ.INV functionLARGE functionSKEW function
CHISQ.INV.RT functionLINEST functionSLOPE function
CHISQ.TEST functionLOGEST functionSMALL function
CONFIDENCE.NORM functionLOGNORM.DIST functionSTANDARDIZE function
CONFIDENCE.T functionMAX functionSTDEV.P function
CORREL functionMAXIFS functionSTDEV.S function
COUNT functionMEDIAN functionSTDEVA function
COUNTA functionMIN functionSTDEVPA function
COUNTBLANK functionMINA functionTREND function
COUNTIF functionMINIFS functionTRIMMEAN function
COUNTIFS functionMODE.MULT functionVAR.P function
COVARIANCE.P functionMODE.SNGL functionVAR.S function
COVARIANCE.S functionNORM.DIST function

Back to top
Text
ASC functionLEFT functionTEXT function
CHAR functionLEN functionTEXTJOIN function
CLEAN functionLOWER functionTRIM function
CODE functionMID functionUNICHAR function
CONCAT functionREPT functionUNICODE function
CONCATENATE functionRIGHT functionUPPER function
EXACT functionSEARCH functionVALUE function
FIND functionSUBSTITUTE function
FIXED functionT function

Back to top
Web
ENCODEURL functionWEBSERVICE function

Back to top