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
CONFIDENCE functionMODE functionSTDEV function
FLOOR functionRANK 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 functionHOUR functionTIMEVALUE function
DATEDIF functionMINUTE functionTODAY function
DATEVALUE functionMONTH functionWEEKDAY function
DAY functionNETWORKDAYS functionWORKDAY function
DAYS functionNOW functionYEAR function
EDATE functionSECOND functionYEARFRAC function
EOMONTH functionTIME function

Back to top
Engineering
BIN2DEC functionBITOR functionDEC2BIN function
BIN2HEX functionBITRSHIFT functionDEC2HEX function
BIN2OCT functionBITXOR functionDEC2OCT function
BITAND functionCOMPLEX 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 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 functionMROUND function
ACOS functionCSC functionMULTINOMIAL function
ACOSH functionDECIMAL functionMUNIT function
ACOT functionDEGREES functionPI function
ACOTH functionEVEN functionPOWER function
AGGREGATE functionEXP functionPRODUCT function
ASIN functionFACT functionRADIANS function
ASINH functionFACTDOUBLE functionRAND function
ATAN functionFLOOR.MATH functionRANDBETWEEN function
ATAN2 functionGCD functionSEC function
ATANH functionINT functionSECH function
BASE functionLCM functionSERIESSUM function
CEILING functionLN functionSIGN function
COMBIN functionLOG functionSIN function
COMBINA functionMINVERSE functionSINH function
COS functionMMULT functionSQRT function
COSH functionMOD function

Back to top
Statistical
AVEDEV functionGEOMEAN functionPROB function
AVERAGE functionGROWTH functionQUARTILE.INC function
AVERAGEA functionLARGE functionRANK.AVG function
AVERAGEIF functionMAX functionSKEW function
AVERAGEIFS functionMAXIFS functionSLOPE function
CORREL functionMEDIAN functionSMALL function
COUNT functionMIN functionSTANDARDIZE function
COUNTA functionMINA functionSTDEV.P function
COUNTBLANK functionMINIFS functionSTDEV.S function
COUNTIF functionMODEMULT functionSTDEVA function
COUNTIFS functionNORM.DIST functionSTDEVPA function
EXPON.DIST functionNORM.INV functionTREND function
FORECAST.LINEAR functionPERMUT functionTRIMMEAN function
FREQUENCY functionPERMUTATIONA functionVAR.P function
GAMMA functionPHI functionVAR.S 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