Function Navigation:

Note: (WS) = Worksheet function, (VBA) = Visual Basic for Applications function

MS Excel: ALL Functions - Category

String Functions

ASC (VBA)
CHAR (WS)
CHR (VBA)
CLEAN (WS)
CODE (WS)
CONCATENATE (WS)
Concatenate with & (WS, VBA)
CURDIR (VBA)
DOLLAR (WS)
EXACT (WS)
FIND (WS)
FIXED (WS)
FORMAT Strings (VBA)

INSTR (VBA)
INSTRREV (VBA)
LCASE (VBA)
LEFT (WS, VBA)
LEN (WS, VBA)
LOWER (WS)
LTRIM (VBA)
MID (WS, VBA)
PROPER (WS)
REPLACE (WS)
REPLACE (VBA)
REPT (WS)
RIGHT (WS, VBA)

RTRIM (VBA)
SEARCH (WS)
SPACE (VBA)
STR (VBA)
STRCONV (VBA)
SUBSTITUTE (WS)
T (WS)
TEXT (WS)
TRIM (WS, VBA)
UCASE (VBA)
UPPER (WS)
VALUE (WS)

Numeric / Mathematical Functions

ABS (WS, VBA)
ACOS (WS)
ACOSH (WS)
AGGREGATE (WS)
ASIN (WS)
ASINH (WS)
ATAN (WS)
ATAN2 (WS)
ATANH (WS)
ATN (VBA)
AVERAGE (WS)
AVERAGEA (WS)
AVERAGEIF (WS)
AVERAGEIFS (WS)
BIN2DEC (WS)
BIN2HEX (WS)
BIN2OCT (WS)
CEILING (WS)
CEILING.PRECISE (WS)
COMBIN (WS)
COMBINA (WS)
COMPLEX (WS)
CONVERT (WS)
COS (WS, VBA)
COSH (WS)
COUNT (WS)
COUNTA (WS)
COUNTBLANK (WS)
COUNTIF (WS)
DEGREES (WS)

EVEN (WS)
EXP (WS, VBA)
FACT (WS)
FIX (VBA)
FLOOR (WS)
FORMAT Numbers (VBA)
FREQUENCY (WS)
INT (WS, VBA)
LARGE (WS)
LN (WS)
LOG (WS, VBA)
LOG10 (WS)
MAX (WS)
MAXA (WS)
MDETERM (WS)
MEDIAN (WS)
MIN (WS)
MINA (WS)
MINVERSE (WS)
MMULT (WS)
MOD (WS)
N (WS)
ODD (WS)
PI (WS)
POWER (WS)
PRODUCT (WS)
RADIANS (WS)
RAND (WS)
RANDBETWEEN (WS)
RND (VBA)

ROMAN (WS)
ROUND (WS)
ROUND (VBA)
ROUNDDOWN (WS)
ROUNDUP (WS)
SGN (VBA)
SIGN (WS)
SIN (WS, VBA)
SINH (WS)
SMALL (WS)
SQRT (WS)
SUBTOTAL (WS)
SUM (WS)
SUMIF (WS)
SUMPRODUCT (WS)
SUMSQ (WS)
SUMX2MY2 (WS)
SUMX2PY2 (WS)
SUMXMY2 (WS)
TAN (WS, VBA)
TANH (WS)
TRUNC (WS)
VAL (VBA)
VALUE (WS)
VAR (WS)
VARA (WS)
VARP (WS)
VARPA (WS)

Statistical Functions

AGGREGATE (WS)
AVEDEV (WS)
AVERAGE (WS)
AVERAGEA (WS)
AVERAGEIF (WS)
AVERAGEIFS (WS)
BETA.DIST (WS)
BETADIST (WS)
BETA.INV (WS)
BETAINV (WS)
BINOM.DIST (WS)
BINOMDIST (WS)
BINOM.INV (WS)
CHIDIST (WS)

CHIINV (WS)
CHITEST (WS)
COVAR (WS)
FORECAST (WS)
GROWTH (WS)
INTERCEPT (WS)
LARGE (WS)
MAX (WS)
MAXA (WS)
MEDIAN (WS)
MIN (WS)
MINA (WS)
PERCENTILE (WS)
PERCENTRANK (WS)

PERMUT (WS)
PI (WS)
QUARTILE (WS)
RANK (WS)
SMALL (WS)
STDEV (WS)
STDEVA (WS)
STDEVP (WS)
STDEVPA (WS)
VAR (WS)
VARA (WS)
VARP (WS)
VARPA (WS)

Logical Functions

AND (WS)
CASE (VBA)
FALSE (WS)
IF (WS)

OR (WS)
TRUE (WS)

Information Functions

CELL (WS)
ERROR.TYPE (WS)
INFO (WS)
ISBLANK (WS)
ISDATE (VBA)
ISERR (WS)

ISERROR (WS, VBA)
ISLOGICAL (WS)
ISNA (WS)
ISNONTEXT (WS)
ISNULL (VBA)
ISNUMBER (WS)

ISNUMERIC (VBA)
ISREF (WS)
ISTEXT (WS)
N (WS)
NA (WS)
TYPE (WS)

Date & Time Functions

DATE (WS)
DATE (VBA)
DATEADD (VBA)
DATEDIF (WS)
DATEDIFF (VBA)
DATEPART (VBA)
DATESERIAL (VBA)
DATEVALUE (WS, VBA)
DAY (WS, VBA)

DAYS360 (WS)
FORMAT Dates (VBA)
HOUR (WS, VBA)
MINUTE (WS, VBA)
MONTH (WS, VBA)
MONTHNAME (VBA)
NETWORKDAYS (WS)
NETWORKDAYS.INTL (WS)
NOW (WS, VBA)

SECOND (WS)
TIME (WS)
TIMESERIAL (VBA)
TIMEVALUE (WS, VBA)
TODAY (WS)
WEEKDAY (WS, VBA)
WEEKDAYNAME (VBA)
YEAR (WS, VBA)

Database Functions

DAVERAGE (WS)
DCOUNT (WS)
DCOUNTA (WS)
DGET (WS)

DMAX (WS)
DMIN (WS)
DPRODUCT (WS)
DSTDEV (WS)

DSTDEVP (WS)
DSUM (WS)
DVAR (WS)
DVARP (WS)

Lookup / Reference Functions

HLOOKUP (WS)
HYPERLINK (WS)
INDEX (WS)
INDIRECT (WS)
LOOKUP (WS)
MATCH (WS)
OFFSET (WS)

ROW (WS)
ROWS (WS)
SWITCH (VBA)
TRANSPOSE (WS)
VLOOKUP (WS)

More Lookup Functions

Data Type Conversion Functions

CBOOL (VBA)
CBYTE (VBA)
CCUR (VBA)
CDATE (VBA)

CDBL (VBA)
CDEC (VBA)
CINT (VBA)
CLNG (VBA)

CSNG (VBA)
CSTR (VBA)
CVAR (VBA)

Financial Functions

ACCRINT (WS)
ACCRINTM (WS)
AMORDEGRC (WS)
AMORLINC (WS)
DB (WS)
DDB (WS, VBA)
FV (WS, VBA)

IPMT (WS, VBA)
IRR (WS, VBA)
ISPMT (WS)
MIRR (WS, VBA)
NPER (WS, VBA)
NPV (WS, VBA)
PMT (WS, VBA)

PPMT (WS, VBA)
PV (WS, VBA)
RATE (WS, VBA)
SLN (WS, VBA)
SYD (WS, VBA)
VDB (WS)

File/Directory Functions

CHDIR (VBA)
CHDRIVE (VBA)
CURDIR (VBA)

DIR (VBA)
FILEDATETIME (VBA)
FILELEN (VBA)

GETATTR (VBA)
MKDIR (VBA)
SETATTR (VBA)

Miscellaneous Functions