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 functionEFFECT functionISPMT function
ACCRINTM functionFV functionRATE 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 functionPRODUCT function
ACOS functionDECIMAL functionRADIANS function
ACOSH functionDEGREES functionRAND function
ACOT functionEVEN functionRANDBETWEEN function
ACOTH functionEXP functionSEC function
AGGREGATE functionFACT functionSECH function
ASIN functionFACTDOUBLE functionSERIESSUM function
ASINH functionFLOOR.MATH functionSIGN function
ATAN functionINT functionSIN function
ATAN2 functionLCM functionSINH function
ATANH functionLN functionSQRT function
BASE functionLOG functionSUM function
CEILING functionMMULT functionSUMIF function
COMBIN functionMOD functionSUMIFS function
COMBINA functionMROUND functionSUMPRODUCT function
COS functionPI functionSUMSQ function
COSH functionPOWER function

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

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

Back to top
Web
ENCODEURL functionWEBSERVICE function

Back to top