Excel Functions


Text
Date and time
Information
Lookup and reference
Database
Logical
ASC
CELL
ADDRESS
DAVERAGE
BAHTTEXT
ERROR.TYPE
AREAS
DCOUNT
CHAR
INFO
CHOOSE
DCOUNTA
IFERROR
CLEAN
ISBLANK
COLUMN
DGET
NOT
CODE
ISERR
COLUMNS
DMAX
OR
CONCATENATE
ISERROR
HLOOKUP
DMIN
FALSE
DOLLAR
ISEVEN
HYPERLINK
DPRODUCT
TRUE
EXACT
ISLOGICAL
INDEX
DSTDEV

FIND
ISNA
INDIRECT
DSTDEVP

FINDB
ISNONTEXT
LOOKUP
DSUM

FIXED
ISNUMBER
MATCH
DVAR

JIS
ISODD
OFFSET
DVARP

LEFT
ISREF
ROW


LEFTB
ROWS


LEN
N
RTD


LENB
NA
TRANSPOSE


LOWER
TYPE
VLOOKUP


MID




MIDB




PHONETIC




PROPER





REPLACE





REPLACEB





REPT





RIGHT





RIGHTB





SEARCH





SEARCHB





SUBSTITUTE





T





TEXT





TRIM





UPPER





VALUE