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 functionRANK function
CHIINV functionFLOOR functionSTDEV function
CHITEST functionFORECAST function
CONFIDENCE functionFTEST 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 functionPMT function
ACCRINTM functionFV functionPPMT function
CUMIPMT functionIPMT functionPRICEMAT function
CUMPRINC functionISPMT functionRATE function
DB functionNOMINAL function
DOLLARFR functionPDURATION 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 functionOFFSET function
AREAS functionHYPERLINK functionROW function
CHOOSE functionINDEX functionROWS function
COLUMN functionINDIRECT functionTRANSPOSE function
COLUMNS functionLOOKUP functionVLOOKUP function
FORMULATEXT functionMATCH function

Back to top
Math and trigonometry
ABS functionCOT functionMINVERSE function
ACOS functionCOTH functionMMULT function
ACOSH functionCSC functionMOD function
ACOT functionDECIMAL functionMROUND function
ACOTH functionDEGREES functionMULTINOMIAL function
AGGREGATE functionEVEN functionMUNIT function
ASIN functionEXP functionPI function
ASINH functionFACT functionPOWER function
ATAN functionFACTDOUBLE functionPRODUCT function
ATAN2 functionFLOOR.MATH functionRADIANS function
ATANH functionFLOOR.PRECISE functionRAND function
BASE functionGCD functionRANDBETWEEN function
CEILING functionINT functionSEC function
COMBIN functionLCM functionSECH function
COMBINA functionLN functionSERIESSUM function
COS functionLOG functionSIGN function
COSH functionLOG10 function

Back to top
Statistical
AVEDEV functionCOUNT functionINTERCEPT function
AVERAGE functionCOUNTA functionLARGE function
AVERAGEA functionCOUNTBLANK functionLINEST function
AVERAGEIF functionCOUNTIF functionLOGEST function
AVERAGEIFS functionCOUNTIFS functionLOGNORM.DIST function
BETA.DIST functionCOVARIANCE.P functionMAX function
BETA.INV functionCOVARIANCE.S functionMAXIFS function
BINOM.DIST functionEXPON.DIST functionMEDIAN function
BINOM.INV functionF.DIST functionMIN function
CHISQ.DIST functionF.DIST.RT functionMINA function
CHISQ.DIST.RT functionF.TEST functionMINIFS function
CHISQ.INV functionFORECAST.LINEAR functionMODE.MULT function
CHISQ.INV.RT functionFREQUENCY functionMODE.SNGL function
CHISQ.TEST functionGAMMA functionNORM.DIST function
CONFIDENCE.NORM functionGAMMA.DIST functionNORM.INV function
CONFIDENCE.T functionGEOMEAN functionPERMUT function
CORREL functionGROWTH function

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

Back to top
Web
ENCODEURL functionWEBSERVICE function

Back to top

Excel Function Reference

This extensive function reference list provides detailed information including syntax, arguments, return values, and examples for many of the functions used in Excel formulas. Click on headers to sort table.