Excel Function List
Arithmetic and operators
=
>
>=
<
<=
<>
+
-
*
/
%
^
Logical
IF
AND
OR
NOT
TRUE
FALSE
Text
CHAR
CLEAN
CODE
CONCATENATE
DOLLAR
EXACT
FIND
FIXED
LEFT
LEN
LOWER
MID
PROPER
REPLACE
REPT
RIGHT
SEARCH
SUBSTITUTE
TEXT
TRIM
UPPER
VALUE
Math and Trig
ABS
ACOS
ACOSH
ASIN
ASINH
ATAN
ATAN2
ATANH
CEILING
COMBIN
COS
COSH
DEGREES
EVEN
EXP
FACT
FLOOR
INT
LN
LOG
LOG10
MOD
ODD
PI
POWER
PRODUCT
RADIANS
RAND
ROMAN
ROUND
ROUNDDOWN
ROUNDUP
SIGN
SIN
SINH
SQRT
SUM
SUMPRODUCT
SUMSQ
SUMX2MY2
SUMX2PY2
SUMXMY2
TAN
TANH
TRUNC
Statistical Functions
AVERAGE
AVERAGEA
AVEDEV
CORREL
COUNT
COUNTA
COUNTIF
COVAR
FORECAST
HYPGEOMDIST
LARGE
MAX
MAXA
MIN
MINA
NORMDIST
NORMINV
NORMSDIST
NORMSINV
PEARSON
RANK
RSQ
SLOPE
SMALL
STDEV
STDEVA
STDEVP
STDEVPA
VAR
VARP
VARA
VARPA
Information
ISBLANK
ISERR
ISERROR
ISEVEN
ISLOGICAL
ISNA
ISNONTEXT
ISNUMBER
ISODD
ISREF
ISTEXT
NA
Lookup and Reference
CHOOSE
COLUMN
COLUMNS
HLOOKUP
HYPERLINK
INDEX
LOOKUP
MATCH
ROW
ROWS
VLOOKUP
Date and Time
DATE
DATEVALUE
DAY
DAYS360
EDATE
EOMONTH
HOUR
MINUTE
MONTH
NOW
SECOND
TIME
TIMEVALUE
TODAY
WEEKDAY
WORKDAY
YEAR
Financial
DB
DDB
FV
IPMT
IRR
MIRR
NPER
NPV
PMT
PPMT
PV
RATE
SLN
SYD
Analysis Toolpak
QUOTIENT
|