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 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 functionEXP functionROUNDDOWN function
ACOS functionFACT functionROUNDUP function
ACOSH functionFACTDOUBLE functionSEC function
ACOT functionFLOOR.MATH functionSECH function
ACOTH functionFLOOR.PRECISE functionSERIESSUM function
AGGREGATE functionGCD functionSIGN function
ASIN functionINT functionSIN function
ASINH functionLCM functionSINH function
ATAN functionLN functionSQRT function
ATAN2 functionLOG functionSUM function
ATANH functionLOG10 functionSUMIF function
BASE functionMINVERSE functionSUMIFS function
CEILING functionMMULT functionSUMPRODUCT function
COMBIN functionMOD functionSUMSQ function
COMBINA functionMROUND functionSUMX2MY2 function
COS functionMULTINOMIAL functionSUMX2PY2 function
COSH functionMUNIT functionSUMXMY2 function
COT functionPI functionTAN function
COTH functionPOWER functionTANH function
CSC functionPRODUCT functionTRUNC function
DECIMAL functionRADIANS functionSUBTOTAL function
DEGREES functionRAND functionQUOTIENT function
EVEN functionRANDBETWEEN 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