Functions alphabetically | Functions by category

Press with mouse 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 functionPV function
ACCRINTM functionFV functionRATE function
AMORDEGRC functionIPMT functionRRI function
AMORLINC functionISPMT functionSYD function
CUMIPMT functionNOMINAL functionTBILLPRICE function
CUMPRINC functionPDURATION functionTBILLYIELD function
DB functionPMT functionVDB function
DDB functionPPMT functionXNPV function
DOLLARFR functionPRICEMAT functionYIELD 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 functionHYPERLINK functionSORT function
AREAS functionINDEX functionSORTBY function
CHOOSE functionINDIRECT functionSTOCKHISTORY function
COLUMN functionLOOKUP functionTRANSPOSE function
COLUMNS functionMATCH functionUNIQUE function
FILTER functionOFFSET functionVLOOKUP function
FORMULATEXT functionROW functionXLOOKUP function
HLOOKUP functionROWS functionXMATCH function

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

Back to top