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 functionFACTDOUBLE functionROUND function
ACOS functionFIXED functionROUNDDOWN function
ACOSH functionFLOOR.MATH functionROUNDUP function
ACOT functionFLOOR.PRECISE functionSEC function
ACOTH functionGCD functionSECH function
AGGREGATE functionINT functionSEQUENCE function
ASIN functionLCM functionSERIESSUM function
ASINH functionLET functionSIGN function
ATAN functionLN functionSIN function
ATAN2 functionLOG functionSINH function
ATANH functionLOG10 functionSQRT function
BASE functionMINVERSE functionSUBTOTAL function
CEILING functionMMULT functionSUM function
COMBIN functionMOD functionSUMIF function
COMBINA functionMROUND functionSUMIFS function
COS functionMULTINOMIAL functionSUMPRODUCT function
COSH functionMUNIT functionSUMSQ function
COT functionPI functionSUMX2MY2 function
COTH functionPOWER functionSUMX2PY2 function
CSC functionPRODUCT functionSUMXMY2 function
DECIMAL functionQUOTIENT functionTAN function
DEGREES functionRADIANS functionTANH function
EVEN functionRAND functionTRUNC function
EXP functionRANDARRAY function
FACT 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 functionLEN functionTEXTAFTER function
CHAR functionLOWER functionTEXTBEFORE function
CLEAN functionMID functionTEXTJOIN function
CODE functionREPT functionTEXTSPLIT function
CONCAT functionRIGHT functionTRIM function
CONCATENATE functionSEARCH functionUNICHAR function
EXACT functionSUBSTITUTE functionUNICODE function
FIND functionT functionUPPER function
LEFT functionTEXT functionVALUE function

Back to top
Web
ENCODEURL functionFILTERXML functionWEBSERVICE function

Back to top