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 functionEOMONTH functionSECOND function
DATEDIF functionHOUR functionTIME function
DATEVALUE functionMINUTE functionTIMEVALUE function
DAY functionMONTH functionTODAY function
DAYS functionNETWORKDAYS functionWEEKDAY function
EDATE functionNOW functionYEAR 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 functionFV functionRATE function
ACCRINTM functionISPMT function
EFFECT functionNOMINAL function

Back to top
Information
CELL functionISLOGICAL functionISTEXT function
INFO functionISNA functionN function
ISBLANK functionISNONTEXT functionNA function
ISERR functionISNUMBER functionSHEET function
ISERROR functionISODD functionSHEETS function
ISFORMULA functionISREF functionTYPE 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 functionMUNIT function
ACOS functionDECIMAL functionPI function
ACOSH functionDEGREES functionPOWER function
ACOT functionEVEN functionPRODUCT function
ACOTH functionEXP functionRADIANS function
AGGREGATE functionFACT functionRAND function
ASIN functionFACTDOUBLE functionRANDBETWEEN function
ASINH functionFLOOR.MATH functionSEC function
ATAN functionINT functionSECH function
ATAN2 functionLCM functionSERIESSUM function
ATANH functionLN functionSIGN function
BASE functionLOG functionSIN function
CEILING functionMINVERSE functionSINH function
COMBIN functionMMULT functionSQRT function
COMBINA functionMOD functionSUM function
COS functionMROUND functionSUMIF function
COSH functionMULTINOMIAL function

Back to top
Statistical
AVEDEV functionFREQUENCY functionQUARTILE.INC function
AVERAGE functionLARGE functionRANK.AVG function
AVERAGEA functionMAX functionSMALL function
AVERAGEIF functionMAXIFS functionSTANDARDIZE function
AVERAGEIFS functionMEDIAN functionSTDEV.P function
CORREL functionMIN functionSTDEV.S function
COUNT functionMINA functionSTDEVA function
COUNTA functionMINIFS functionSTDEVPA function
COUNTBLANK functionMODEMULT functionTREND function
COUNTIF functionNORM.DIST functionTRIMMEAN function
COUNTIFS functionNORM.INV functionVAR.P function
EXPON.DIST functionPERMUT functionVAR.S function
FORECAST.LINEAR functionPERMUTATIONA function

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

Back to top
Web
ENCODEURL functionWEBSERVICE function

Back to top